| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I generate random, non-repeating numbers that don't change?
I'm setting up a spreadsheet that tracks names and generates random,
non-repeating four-digit ID#'s. Is it possible in Excel 2000? |
|
#2
|
|||
|
|||
|
The usual way to generate non repeating random numbers is to make a
complete list of the possible numbers use =RAND() in and adjacent column, then sort both columns by that auxiliary column and read of the desired number of values from the first column. Jerry bsquared0 wrote: I'm setting up a spreadsheet that tracks names and generates random, non-repeating four-digit ID#'s. Is it possible in Excel 2000? |
| 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) | |||
| How do I generate random numbers using dates in excel? | Excel Worksheet Functions | |||
| Generate random numbers between two values and with a given mean | Excel Worksheet Functions | |||
| generate random numbers | Excel Worksheet Functions | |||
Linear Mode
