Removing duplicates from Two columns?

**dawsonsoo** · 03-08-2010, 02:28 PM

Hi,
In column A, I have 500 email addresses.
In column B, I have 35 email addresses.

I want to see if ANY of the 35 email addresses in column B exist in Column A and if they do, remove them from column A.

A while back, someone suggested:
=Isnumber(Match(A1,X:X,0)) will return TRUE if value in A1 matches anything in column X... then you can delete the ones where TRUE shows.

But for some reason, EVERYTHING is returning as false. Can someone please help me a) by giving me a new formula to try? or b) help me troubleshoot what's wrong with the above formula where I'm only getting False results?

P.S. I already know that the 35 email addresses in column B are duplicated in the larger list of column A with 500 email addresses. I just don't want to have to go and delete manually by using the "find" feature. Thanks in advance!

**ChemistB** · 03-08-2010, 02:39 PM

If you want to see if any in column B occur in column A, the formula would read

Please Login or Register  to view this content.

This is looking for an exact match also so if you have blank spaces or other descrepancies, it may be reading as False. If you are still having problems, troubleshoot by copy/paste one from Col A into B and see if that gives you a True

**dawsonsoo** · 03-08-2010, 03:01 PM

Thank you - I AM still having trouble. If I copy/paste Col B data into Col A, what would the formula be?

**ChemistB** · 03-08-2010, 04:10 PM

Can you upload an example of how your spreadsheet is set up including your formulas? Click on "New Post" at the bottom of the screen and scroll down to "manage attachments." If I see an example, I can tell you what's wrong.

**dawsonsoo** · 03-08-2010, 04:21 PM

Hi,
Here's an example. Thank you SO MUCH for your help!

**ChemistB** · 03-08-2010, 05:19 PM

Your values in column B have a blank space after each one. You can either manually delete each one or you can use the TRIM function in a separate column and then compare that new column to column A. See attachment.