|
Posted to microsoft.public.excel.programming
|
|
|
unique random numbers
Tom, how is this done?
xnman
Tom Ogilvy wrote:
The best way is to use a method that only assigns unique random numbers.
This can be done without using kludge methods.
--
Regards,
Tom Ogilvy
jasonsweeney wrote in message
...
Yep.
Best way is to use really large random numbers where the odds of 2 of
your 500 students getting the same random number is very small. Then
Just sort the column.
I assume you want to give the students a number so you can post their
grades. To do this, you may want to truncate the large random number
to 3 digits and then sort, keeping in mind that as the random number
gets smaller the odds of two students with the same number
increases....you can right a simple function to test this of course.
---
Message posted from http://www.ExcelForum.com/
|