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!