I'm setting up a spreadsheet that tracks names and generates random,
non-repeating four-digit ID#'s. Is it possible in Excel 2000?
I'm setting up a spreadsheet that tracks names and generates random,
non-repeating four-digit ID#'s. Is it possible in Excel 2000?
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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks