| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
random list in excel
I have a list of 80 names that has to be randomly put in to an order where
all the names are used only once. How do I do that |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
random list in excel
All I can say is that if you have a column with =Rand()
You will get non-equal numbers (the odds of a repeting number are very low). Replace the formula with PasteSpecial Value. Sort everything by that column and you get a random ordered list. There are many ways that you can do this in code, or manually. -- steveB Remove "AYN" from email to respond "Lw" wrote in message ... I have a list of 80 names that has to be randomly put in to an order where all the names are used only once. How do I do that |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| random ordering a list in excel | Excel Worksheet Functions | |||
| How can I make random selection from excel list? | Excel Discussion (Misc queries) | |||
| list names in random order in Excel 2002 | Excel Discussion (Misc queries) | |||
| If I create a random list in Excel, does it repeat numbers? | Excel Worksheet Functions | |||
| How do I find random number in list of random alpha? (Position is. | Excel Discussion (Misc queries) | |||
Linear Mode
