find names on list 1 in list 2. list 1 4000 names list 2 400 name

[Guest]

I need help comparing 2 lists in excel. Here is my goal; I have one list with
4500 names and one list with 400 names. I would like to find out which of the
400 names is on the 4500 name list. how do I do it? thanks for your help.

 

[Peo Sjoblom]

You can use the technique described here

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

--
Regards,

Peo Sjoblom

(No private emails please)