Have two columns. First column Contains the random number. Next column has
the numbers 1 to 36,000. Then sort by the random numbers. The number 1 to
36,000 wil be now be random.

"Ryan" wrote:

I want to generate a list of random numbers (36,000 of them) such that no two
are alike. I know how to do the random part [=RAND()*(b-a)+a] for random
numbers between a and b. Do you know how to ensure no two are alike?

I'm currently using the following formula

=ROUND(RAND()*(36000-0)+0,0)