Unique Random Numbers

[Joe Schmo]

I'm looking for a way to generate a list of "unique" random numbers from 1
to x.

For example I have a list of students and would like to randomly scramble
that list. The number of students changes so I need the ability to idicate
the number of students.



Thanks in advance

 

[Jim Cone]

You don't need programming code.
Enter "=Rand()" in an adjoining column and fill down.
Sort both columns using the rand column as the key.

Or give my free workbook "Special Randoms" a try.
You can download it from... http://excelusergroup.org/
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Joe Schmo"
wrote in message
I'm looking for a way to generate a list of "unique" random numbers from 1
to x.
For example I have a list of students and would like to randomly scramble
that list. The number of students changes so I need the ability to idicate
the number of students.
Thanks in advance

 

[Bernd P]

Hello,

You can take my UDF UniqRandInt:
http://www.sulprobil.com/html/uniqrandint.html

Regards,
Bernd