i am working on the file, there are 20 different category i want to get sample 5 % sample or minimum 1 and maximum 25 . thanks
Solved! Go to Solution.
i am working on the file, there are 20 different category i want to get sample 5 % sample or minimum 1 or maximum 25 . thanks
@vkirans123 I recommend posting your data or at least a sample of the format with random values if the data is confidential
@vkirans123
The Randome % sample is not having a Grouping feature. 😂
Therefore the batch macro comes to be helpful.
I am not sure the requirement of "minimum 1 and maximum 25" so I made two condition,
1 is for 5% sample only
2 is for %5 sampling and limite the sample records to be under or equal 25 records.
thank you for your prompt response.
this is exactly what i needed . thanks. is it works the same if my source file has multiple tabs.