Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Has anyone developed a formula for selecting random items from a group?
Given the size of the group "G" and the number of samples "S" required to be selected from it, I want to create an ordered list of randomly selected sequence numbers from G up to the total number of S with each selection being excluded from subsequent selections. (Just like picking numbered ping-pong balls from a bag, once selected that number is no longer available to be selected. Example: I have a group size of 100 units. I want to randomly select 10 units from the sequence of 1-100. The output I want might be something like 1 2 2 3 6 7 7 8 9 This would be a supposedly random selection of 10 unique sequence numbers from the group of 100 units If anyone has a solution, please let me know Thanks, Scott |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Random Sampling | Excel Discussion (Misc queries) | |||
Random Sampling - Please Help! | Excel Worksheet Functions | |||
Random Sampling | Excel Discussion (Misc queries) | |||
Random Sampling | Excel Discussion (Misc queries) | |||
Random Selection of items in Excel? | Excel Discussion (Misc queries) |