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/

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/

=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/

.

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