HomeBetterSolutions.com
  • Microsoft Office Expertise
    Microsoft Office ExcelMicrosoft Office WordVBA ProgrammingC# ProgrammingJavaScript Programming
  • Bespoke Development
    Office Add-in DevelopmentJavaScript Office Add-insVSTO and C# IntegrationHigh Value ConsultancyCase Studies and Experience
  • Technical Support
    VBA Macro SupportEnd User ProgrammingFront Office EUDAsCode OptimisationOffice 365 Migration
  • Get In Touch
Add-ins > Excel Custom Functions

  • Add-ins
  • Custom Functions
  • User FAQs ...
  • Sample Data
  • CITIES
  • CITIES-MONTHS
  • CITIES-MONTH-MONTH
  • COUNTRY-VALUE-CODE
  • COUNTRY-VALUE-CITY
  • DATES-BIRTHDAYS
  • LOCATION-MONTH-DEPT
  • SECTOR-CODE-PRICE-CODE
  • USERNAME-DEPT-TOTAL
  • Complete List
  • Category - Counting ...
  • Category - Summing ...
  • Category - Text ...
  • Category - Date & Time ...
  • Category - Formatting ...
  • Category - Information ...
  • Category - Maths ...
  • Category - Other ...
  • Updated: 18 October 2022
  • 18 October 2022

SAMPLEDATA([tableName])

Returns sample data into your worksheet.
If no tableName is provided then LOCATION-MONTH-DEPT is the default.


tableNameDescription
CITIES 
CITIES-MONTHS 
CITIES-MONTH-MONTH 
COUNTRY-VALUE-CODE 
COUNTRY-VALUE-CITY 
DATES-BIRTHDAYS 
LOCATION-MONTH-DEPT 
SECTOR-CODE-PRICE-CODE 
USERNAME-DEPT-TOTAL 
tableName
Description
CITIES
CITIES-MONTHS
CITIES-MONTH-MONTH
COUNTRY-VALUE-CODE
COUNTRY-VALUE-CITY
DATES-BIRTHDAYS
LOCATION-MONTH-DEPT
SECTOR-CODE-PRICE-CODE
USERNAME-DEPT-TOTAL

© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited TopPrevNext