Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Allow selection of multiple values in dropdown list in excel | Excel Discussion (Misc queries) | |||
How do I pull a random sample of people from a list in excel? | Excel Worksheet Functions | |||
Random Selection of items in Excel? | Excel Discussion (Misc queries) | |||
How to create a Sub validation list in excel? | Excel Discussion (Misc queries) | |||
limit cell list selection based on the selection of another list | Excel Worksheet Functions |