Excel Comparing columns with emails

Microsoft Microsoft office excel 2007 ac...
February 26, 2011 at 19:16:35
Specs: Windows XP
Ok, I tried just about everything. I have two columns of emails. Column A & B is a masterlist of names with email address. Column C is a list of emails replied from the master list. I need to compare B and C to see who has replied. I copied the master list and reply emails into excel. I wonder if they are somehow formated differently. If I type in a new entry on the master list and make a coorisponding email in the reply list and run a formula that one will show up, but not the others. So I know I have the formula right. I just can't figure out what is wrong with my data. I have tried conditional formating to find duplicates, but it did not find any. If I use FIND it does find the two same enteries.

This is the formula that I'm using. =IF(ISERROR(MATCH(N1,$P$1:$P$637,0)),"",N1)

N having the master emails and P having the reply emails.

See More: Excel Comparing columns with emails

February 28, 2011 at 10:37:56
OK here is the answer. After many many hours of working with this issue. One set of email addresses had a space on the end. The other did not.

Report •
Related Solutions

Ask Question