How can I make random selection from excel list?
Try this:
Assume your names are in the range A1:A800.
Enter this formula in B1 and copy down to B800:
=RAND()
Now, select both column A and B and do a sort on column B (either ascending
or descending, it doesn't matter).
Use the first 10 rows of column A for your random picks.
Biff
"DD" wrote in message
...
I have an excel spreadsheet with 800+ names. I need to do a random drawing
to select 10 names for a prize. What is the easiest way to do this?
|