ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I recognize duplicate cells in multiple columns? (https://www.excelbanter.com/excel-discussion-misc-queries/106336-how-do-i-recognize-duplicate-cells-multiple-columns.html)

cp mccall

How do I recognize duplicate cells in multiple columns?
 
Column A & B have email addresses. Column B are bad addresses, how do I know
if they exist in column A?

Peo Sjoblom

How do I recognize duplicate cells in multiple columns?
 
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?





All times are GMT +1. The time now is 08:31 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com