Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Random Selection
Hello all,
I am attempting to generate a random group of names from a list and am having a bit of trouble. In a previous posting I found the formula =INDEX(A4:A15,INT(RAND()*(12-1)+1)), which is perfect for selecting a single name. The trouble that I have is that I need a random sample of 20% of the list. Copying the formula into multiple cells leaves open the chance that any given name can be selected multiple times. Does anyone know a way to perform this same function in subsequent cells, while excluding previously selected names? Thank you for your help. Craig |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Random number selection | Excel Worksheet Functions | |||
Random Selection | New Users to Excel | |||
Random question / data selection | Excel Worksheet Functions | |||
Random Selection | Excel Worksheet Functions | |||
How can I set up the random selection of a cell from within a ran. | Excel Discussion (Misc queries) |