Random Selection

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Cookie - 02 May 2006 23:35 GMT

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

Reply to this Message

Gary''s Student - 02 May 2006 23:51 GMT

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.

Signature

Gary's Student

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

Reply to this Message

JE McGimpsey - 03 May 2006 00:05 GMT

Take a look here:

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

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

Reply to this Message