Duplicates in Excel 2007

[DiDance]

I have 7 worksheets with information on alumni including unique ID, name, and degree information. An individual can have multiple degrees from different schools across the 7 worksheets. (Each worksheet is a school such as Business, Nursing, Education, etc.) What is the best way for me to determine if a person on one worksheet also shows up on any of the other 6 sheets?

An example would be if #1234, Bob Jones has a BS in Chemistry on one worksheet and an MBA on another. I would like to see all of these results on one worksheet.

Thanks.

Diana

 

[cjcobra]

I would set up a tab that has all the names in it. Then next to each name, VLOOKUP that name (or number) for each tab (or degree), and put a blank if it hits an error, or display the degree type.