Random Selection

[Cookie]

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

 

[Gary''s Student]

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.

 

[JE McGimpsey]

Take a look here:

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