Unique Number

[Guest]

As a teacher, I would like to assign each student a randon number that is
unique from any other student number. How am I able to do this?

 

[Guest]

what is the format of the number you are trying to assign?
how many students do you have?

 

[Bernard Liengme]

Random number no duplicates
http://www.tushar-mehta.com/excel/newsgroups/rand_selection/index.html

 

[Guest]

Say you want random 4 digit numbers (range 1000-9999).

Enter the values 1000 thru 9999 in column A.
Enter =RAND() in column B and copy down

Sort both columns A & B by B. This "shuffles" the values in column A

Then just pick the first 30 or so values from column A

 

[Guest]

A four digit whole number with no repeats. Ther are about forty student in
each of five classes.

 

[Guest]

See gary"s students sugestion below.

A four digit whole number with no repeats. Ther are about forty student in
each of five classes.