Hi. I would like to ask how to do a random sampling where the file can be shared but the result generated would be the same.

I am not familiar with the functions but I found the data analysis way but that means each of us in the team will need to do it manually and get different results.

The thing is the data will be exported every week and each member will list all the transaction IDs processed. The QRs need to get 5% from each CSR. Using the Sampling method in data analysis, we need to calculate 5% of each CSR and randomly generate the results in another sheet. Thus, the result vary every time.

Is there a way to randomly pick 5% from each column and obtain the same result if the Team Lead runs the same formula?

I have attached a sample report.

Hope someone could help me figure this out.

Thank you.

sample 3.xlsxsample 3.xlsx