Student Class Schedule Checking

I am scheduling 100 students for class at a school for learning differences. Normally we use a Word doc with one page for each class period on a legal sheet of paper.

Each kid's name should appear on a each sheet exactly one time meaning that he/she is scheduled for a class at each period.

I want to check the list of students and make sure each student's name appears once and only once. Ideally, I'd love to spit out a list of students who are missing and a list of students who appear more than once.

any help would save me from a panic attack! just a push in the right direction would be great.

thanks
Don Watford
Savannah, Georgia

Welcome to the board
Hope this sets you on track :http://www.cpearson.com/excel/Duplicates.aspx