Excel Random Sampling

[Justin]

I need to create a spreadsheet that will take a random sampling of 6.25% of
items located on 6 different sheets. The 6.25% needs to be random on each
sheet and not include items already chosen for the sampling. This result
sheet should list the number of items sampled from each of the 6 different
spreadsheets.

Thanks,

Justin

 

[tom_n_ape]

Is the number of items on each of the six sheets fixed? For example,
do you have 100 items on each sheet and then you would like to
randomly sample 6.25% of 100 (or any other fixed number)? If so, then
just use the random number generator to generate unique, integer
numbers from 1 to 100 (or any other fixed number), then sample the
data at those locations and store in the results sheet, then do this
procedure 5 more times to sample all six sheets. The unique, integer
numbers would correspond to the row numbers where the data is found on
each of the six sheets.

~tom

 

[Justin]

No, each sheet contains different number of items. Also what I am sampling is
host names of computers so they are non-numeric.