I am trying to select random sampled invoices for auditing based on population size (say 10% of population) and certain parameters based on the formulas. However I am getting duplicate samples some of the time. Can someone please review attached file Cell Q1047720 and onwards and suggest changes to the formula to avoid duplicate sample selection.
Please bear in mind below: -
1. Population size will vary month on month and so the sample size
2. 10% sample of overall population is based on certain parameters (Research related and more than $2000) so the formula in O1047720 and P1047720 onwards are required
3. Certain rows will need manual elimination through Macros in Row 1 to 100000 therefore these rows cannot be used to place formula for sample selection
Thanks for your help in advance.
Regards
Anil
Bookmarks