Export sample data only without exporting or downloading a entire workbook.
If you would like to create a sample of your data set, you can add a column to it and fill it with random numbers via the function RAND. Then you need to set up a Simple Filter for that column with less equals 0.1 constant and the option to Create filter in new sheet.
After processing your workbook, you will have the possibility to Download the small sample set from the newly created sample sheet, whereby the quality of the sample set will depend on the size of your input data set.
Please sign in to leave a comment.