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




--
Regards,

Peo Sjoblom



"japc90" wrote in message
ups.com...
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!

Hi,

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

HTH
Martin

"japc90" wrote in message
ups.com...
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!

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.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"japc90" wrote in message
ups.com...
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!