See Chip Pearson's page on Duplicate and Uniques

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

--
Regards,
Tom Ogilvy

"kateshere" wrote in message
...
I have two lists of part numbers. I want Excel to compare the lists and
display the duplicates. I have tried filtering and this does not work for
me.