How do I compare two lists of names in excel?
 

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?

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

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


Jack the Cate wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html