Compare 2 Columns of Email Addresses to Find Duplicates?

**elfaye11** · 02-06-2011, 05:04 PM

Hello all! What I am trying a accomplish is to compare two columns of email addresses to find the duplicates. Then, I need to be able to sort or somehow organize the identified duplicates. There are 2,369 addresses in column A, and 5,360 in column B.

I have tried a number of formulas found online, but nothing seems to work. I'm a novice at Excel functions and would greatly appreciate help with this.

Thank you!
Laura

**jeffreybrown** · 02-06-2011, 05:26 PM

Hi Laura & Welcome to the board,

In C1 you could use =IF(COUNTIF($A$1:$A$2369,B1)>=1,"Dup","Nope") which will look at A1:A2369 and tell you if anything is the same as anything in B1.

Adjust the range to meets your needs. This formula you would drag down to the length of column B.

After this you will have numbers, 0 = no match and 1 = match. If you get anything above 1 then it means you have more than duplicates. It could be repeated more than once.

**Richard Buttrey** · 02-06-2011, 05:29 PM

Hi,

What's the ultimate objective? Are you looking to extract from both lists a list of unique names?

Regards

**elfaye11** · 02-06-2011, 10:30 PM

Wow, thank you! That was an absolutely perfect formula, worked great. Wish I had come here first for help!

Thanks

Laura

**jeffreybrown** · 02-07-2011, 08:32 AM

Glad it worked for you Laura.

If you are satisfied with the answer you received, please don't forget to mark your thread as solved.

How to mark a thread as solved