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

scroll down to

Extracting Values Common To Two Lists

--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)



"cp mccall" <cp wrote in message
...
Column A & B have email addresses. Column B are bad addresses, how do I
know
if they exist in column A?