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?

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

"JDay" wrote:

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?

Random number no duplicates
http://www.tushar-mehta.com/excel/ne...ion/index.html
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"JDay" wrote in message
...
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?

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
--
Gary''s Student - gsnu200744


"JDay" wrote:

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?

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

"bj" wrote:

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

"JDay" wrote:

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?

See gary"s students sugestion below.

"JDay" wrote:

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

"bj" wrote:

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

"JDay" wrote:

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?