Comparing lists

[Prixton]

Hi,
I have two lists that I want to compare. I want to find out differences and
if there are duplicates in a list.

 

[Frank Kabel]

Hi
see:
http://cpearson.com/excel/duplicat.htm#ExtractingCommon
http://cpearson.com/excel/duplicat.htm#InOneNotOther

 

[Jim May]

Start here: (move up and down the page - for different methods)...

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

HTH