Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SAMPLING FOR AN AUDIT
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
SAMPLING FOR AN AUDIT
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 --------------- Jacob Skaria "Melinda" wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sampling | Excel Worksheet Functions | |||
Sampling | Excel Discussion (Misc queries) | |||
Sampling | Excel Discussion (Misc queries) | |||
Sampling | Excel Discussion (Misc queries) | |||
Sampling | Excel Discussion (Misc queries) |