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!