Random Selection
 

How do I randomly select say 6 names from an 18 word list from excel?

Random Selection
 

Put the names in a column (say from A1 thru A18) in B1 thru B18 enter:

=RAND()

Sort the data by column B. This shuffles the names in column A. Just pick
the top six. To get another sample just re-sort and pick the top six again.
--
Gary's Student


"Cookie" wrote:

How do I randomly select say 6 names from an 18 word list from excel?

Random Selection
 

Take a look he

http://mcgimpsey.com/excel/udfs/samplenoreplace.html

In article ,
Cookie wrote:

How do I randomly select say 6 names from an 18 word list from excel?