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?
|