Find Duplicates Formula

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

http://www.ozgrid.com/forum/showthread.php?t=78522

Hi Everyone!

I need some help modifying a formula. In the attached spreadsheet, have 1 column with email addresses separated by a semi-colin. Sometimes, the email addresses are the same. With some help from some great online friends, a formula was created to look at the 2 email addresses in the same cell, decide if they are duplicates, and return only one email address (without the semi-colin).

This formula has been working great until recently as the cells can now have 3 email addresses in the same cell. (don't worry there won't be more that 3). Is there a way to modify the formula to look and see if the second and third email addresses are duplicates?

Hi Everyone,

I need your help! I have a spreadsheet that contains 1-3 email addresses in a single cell separated by a semi-colin. Some of the email addresses are duplicated. Is there a formula/function that can look at the email addresses in the cell, and return the email addresses removing the duplicates?

I have attached a sample document with my desired outcome.

Thanks in advance for the help,
Julie

Hello. This is probably a pretty basic question.

I'm trying to compare two columns of email addresses to check for duplicates and then tally those duplicates. It's only duplicates that I'm interested in.

I've tried a nested IF function that I got from a Microsoft article. Here it is:
=IF(ISERROR(MATCH(A12,$C$2:$C$377,0)),"no match","match")

I think it's wrong because the results make no sense.

The columns are of unequal length, with about three times the number of addresses in one column compared to the other. I want to see how many of the addresses in the shorter column are duplicated in the longer one.

I've been fiddling with it for a while now and have managed to confuse myself, so I'd be very grateful if someone could either correct my function or perhaps suggest an alternative method to achieve the same result.

Thanks!

Hey everyone,

I've been trying to get my head around this since long but cannot quite figure it how to do it.

I have an Excel sheet with a single column that lists about a 1500 email addresses. There are a lot of duplicates, and I want to count them.

The output I need to get should look like this:

EmailAddress -------------- # of Occurences
Email Add 1 ---------------------------- 4
Email Add 2 ---------------------------- 4
Email Add 3 ---------------------------- 4
Email Add 4 ---------------------------- 3
Email Add 5 ---------------------------- 3
Email Add 6 ---------------------------- 3
Email Add 7 ---------------------------- 2
Email Add 8 ---------------------------- 2
Email Add 9 ---------------------------- 2
Email Add 10 -------------------------- 2
Email Add 11 ------------------------- 1
Email Add 12 -------------------------- 1

So basically, counting the number of times an email address is in the column and arranging them in descending order.

I was able to highlight the duplicates using Conditional Formatting and CountIf, but I cannot figure out how to get the above output.

Any ideas on how to do this are appreciated