The free "Special Randoms" workbook will do that.
Enter minimum and maximum numbers allowed and set size.
Numbers added to a new workbook - copy and paste where you want.
No registration required. Download from the Products page at my website ...
Portland, Oregon USA
(Excel Add-ins / Excel Programming)
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