Compare Email addresses

Microsoft Microsoft office excel 2007 ac...
February 26, 2011 at 17:38:22
Specs: Windows XP
Ok, I tried just about everything. I have two columns of emails. Column A is a masterlist of names with email address. Column B is a list of emails replied from the master list. I need to compare A and B 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: Compare Email addresses

Report •

February 26, 2011 at 18:02:02
This will be better answered here:

Report •
Related Solutions

Ask Question