SAMPLING FOR AN AUDIT

[Melinda]

I am in desperate need of some help for a project I am working on for an
audit. I need to create a sampling "template" that I put in the Beginning
Number, Ending Number, and the sample size and excel will generate a random
sample list for me. The only columns that I need to have is the sample #
(from 1 to whatever depending on how big the sample size is), and the random
sample number that is generated. I want excel to automatically generate a
new sample number if it has already been chosen (I guess this means that I
want replacement?) I do not want to have sample number chosen more than one
time (because for the audit I wouldn't pull that invoice number to audit more
than once). I hope this makes sense. I do not know anything about array
formulas, vba, or defined user functions, and I am so overwhelmed with all of
the posts and research that I have done to try to figure out this
problem---so if you can help me please provide lots of instructions. I
appreciate any help, and if possible ASAP. THANK YOU!

 

[Jacob Skaria]

Suppose ColA contains all entries or the unique identification number which
represent each item in the population.(eg: 1,2,3,....n) If column B enter
=RAND() and copy down as Col A. Sort both columns by Col B. Then pick the top
10 if your sample size is 10.

If this post helps click Yes