| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Random list (1-45) without repeating numbers?
I'm using Excel 2003. I'm trying to randomize the order of a list of items.
Unfortunately, the only way I've found to do that is to go through item by item and generate a random number for each, checking manually to insure that there are no repeats. There has to be a better way. Randbetween didn't help either, as it also does not weed out repeats. Any way to do this? |
|
#2
|
|||
|
|||
|
See
http://www.mcgimpsey.com/excel/randint.html In article , "Hayes" wrote: I'm using Excel 2003. I'm trying to randomize the order of a list of items. Unfortunately, the only way I've found to do that is to go through item by item and generate a random number for each, checking manually to insure that there are no repeats. There has to be a better way. Randbetween didn't help either, as it also does not weed out repeats. Any way to do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Generate random numbers 1-100 without any repeats? | Excel Worksheet Functions | |||
| Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
| Extracting Values on one list and not another | Excel Discussion (Misc queries) | |||
| Setting up a random list from long list of names ? | Excel Discussion (Misc queries) | |||
| generate random numbers | Excel Worksheet Functions | |||
Linear Mode
