You can use the technique described here

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

--
Regards,

Peo Sjoblom

(No private emails please)


"Ed" wrote in message
...
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.