View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ScottDL ScottDL is offline
external usenet poster
 
Posts: 1
Default Random selection of items from a group (AQL sampling)

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