How do I compare two lists of names in excel?

[Jack the Cate]

I am comparing 2 lists of attendances to conferences, so there are large
numbers to go through, and 1 list will have more attendees than the other.
Is there any formula I can use in excel to highlight names that appear only
in the larger of the 2 lists?

 

[Debra Dalgleish]

Chip Pearson has information on finding and tagging duplicate entries in
a list.

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