View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] sandeep_banga@hotmail.com is offline
external usenet poster
 
Posts: 1
Default Comparing two columns with email addresses

Hello,

I am trying to compare two columns that contain email addresses. The
goal is to identify email addresses that exist in both columns. I
tried VLOOKUP, and Countif functions but I can't get them to return
any results. I also did a copy and paste special (multiply) to make
sure the formatting in both columns is the same.

Column A has email addresses of people who read the email (total 168)
I sent out, and Column C has all the email addresses (total 1938) it
was sent to.

Can anyone please help?

Thank you!
Sandeep