Random Number Assignment

  • Thread starter Thread starter japc90
  • Start date Start date
J

japc90

I have a list of names and I want to assign a number (1-76) to each of
these names. But I do not want duplicate numbers. I tried RAND and
RANDBETWEEN but these formulas are not dependent on the previous
formulas so duplicate numbers are being generated. Any suggestion?

Thank you in advance!
 
Use a help column, put 1 to 76 in A1:A76, then in B1 put =RAND()
copy down to B76, select both columns and sort by column B.
Remove column B and now the numbers in A are in random order
 
With your names in A1 to A76, enter the Rand function in an out-of-the-way
location, say Z1:

=RAND()

And copy down to Z76.

Now, enter this formula in B1:

=INDEX(ROW($A$1:$A$76),RANK(Z1,$Z$1:$Z$76))

And copy down to B76.

This will give you a random list of numbers next to your name list, without
any duplication.

EACH time you hit <F9>, you'll get a new random list.
 
Back
Top