Random Number Assignment

[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!

 

[Peo Sjoblom]

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

 

[MartinW]

Hi,

There is a workaround using RAND. Take a look here.
http://www.mcgimpsey.com/excel/udfs/randint.html

HTH
Martin

 

[RagDyer]

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.