Unique Random Numbers

  • Thread starter Thread starter Joe Schmo
  • Start date Start date
J

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
 
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
 
Back
Top