View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Biff Biff is offline
external usenet poster
 
Posts: 1,688
Default 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?