Problem finding duplicate email addresses

  • Thread starter Thread starter SandeepBanga
  • Start date Start date
S

SandeepBanga

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
 
You can go to Chip Pearson's web site, scroll down to the D's, and check out
all the pages on dealing with duplicates:

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !









- Show quoted text -
Click to expand...

Thanks a lot I will check it.
 
Back
Top