unique random numbers
 

I need to assign a unique random number to 500 students in an excel
worksheet. Can anyone tell me how to do this?


---
Message posted from http://www.ExcelForum.com/

unique random numbers
 

Hi
have a look at
http://www.mvps.org/dmcritchie/excel/random.htm

HTH
Frank

I need to assign a unique random number to 500 students in an excel
worksheet. Can anyone tell me how to do this?


---
Message posted from http://www.ExcelForum.com/

unique random numbers
 

=RAND()*10000000 in the adjacent cell and then copy down
the list of students and then sort by the column with the
formula in.


-----Original Message-----
I need to assign a unique random number to 500 students
in an excel
worksheet. Can anyone tell me how to do this?


---
Message posted from http://www.ExcelForum.com/

.

unique random numbers
 

Yep.


Best way is to use really large random numbers where the odds of 2 o
your 500 students getting the same random number is very small. The
Just sort the column.

I assume you want to give the students a number so you can post thei
grades. To do this, you may want to truncate the large random numbe
to 3 digits and then sort, keeping in mind that as the random numbe
gets smaller the odds of two students with the same numbe
increases....you can right a simple function to test this of course

--
Message posted from http://www.ExcelForum.com

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/