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!