Random Selection

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

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?

Take a look here:

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

In article <[email protected]>,
Cookie <[email protected]> wrote:

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