Common enteries

[Guest]

Good day,
I need to manage a databse of student numbers

I have a worksheet for each class, about 1200 students
I manualy create a student number for each student.
The student number has to be unique, so I have created the first sheet in
the file to contain all the student numbers.

1) Can I run a check to view / highlight only the duplicated student numbers??

2) Is there an easier manner of verifying that I have not duplicated the
student numbers??, maybe as I am busy creating the student numbers on each
new class sheet?

Thanx !!

 

[RagDyeR]

Check out a multitude of web pages on handling duplicates from Chip Pearson.

Scroll down to the D's:

http://www.cpearson.com/excel/topic.htm


--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

Good day,
I need to manage a databse of student numbers

I have a worksheet for each class, about 1200 students
I manualy create a student number for each student.
The student number has to be unique, so I have created the first sheet in
the file to contain all the student numbers.

1) Can I run a check to view / highlight only the duplicated student
numbers??

2) Is there an easier manner of verifying that I have not duplicated the
student numbers??, maybe as I am busy creating the student numbers on each
new class sheet?

Thanx !!