| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
random draw from list of names
i want to do a draw from a list of names. some names appear multiple times
because it is a ballot draw. is there a function where i can shuffle the names and then have excel randomly draw a name? i tried randombetween but right now the names are in order and one name keeps coming up repeatedly. any suggestions would help, thank you, jat |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
random draw from list of names
Hi,
Put the formula =RAND() in an adjacent column and sort the banes and this column and the name at the top will be random. Mike "jat" wrote: i want to do a draw from a list of names. some names appear multiple times because it is a ballot draw. is there a function where i can shuffle the names and then have excel randomly draw a name? i tried randombetween but right now the names are in order and one name keeps coming up repeatedly. any suggestions would help, thank you, jat |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Random names from short list | Excel Worksheet Functions | |||
| create a random list of names from a list of names in EXCEL | Excel Worksheet Functions | |||
| random pick names from the list | Excel Discussion (Misc queries) | |||
| list names in random order in Excel 2002 | Excel Discussion (Misc queries) | |||
| Setting up a random list from long list of names ? | Excel Discussion (Misc queries) | |||
Linear Mode
