Auto Random Sampling

[rpanuganti]

Hi Friends,

I've an excel file with 442 columns (Sheet 1).

• Column D has user names.

I would like to run an auto random sampling with the below criteria.

• Sampling base is user Names (Column D)
• Sampling % is 10%
• If the user has less than 10 documents, system should pick at least one document randomly.

I want to have the date in the Sheet 2 against user names.

This is a showstopper for my work now. Kindly give me a solution.

Thanks in advance

attaching the file.