Trying to count the number of occurrences of duplicate values

Hi All. New to the forum. I have a list 4000 names, addresses, etc. I'm trying to remove all of the duplicate records. There are over 1500.
I can sort them by email address. Then I want to eliminate all duplicates, after the first occurrence of the row.

A B
[email protected] 1
[email protected] 2
[email protected] 3
[email protected] 4
[email protected] 1
[email protected] 2
[email protected] 3
[email protected] 1
[email protected] 2
etc.

I have MS excel 2010

Can someone help me with the formula? Or offer a better solution

Hi,

Welcome to the Forum.

Pivot Table would be better solution for this.

This formula is really close. It does give me some strange results. I'll give you and example

Email Dupe Count Result Desire
[email protected] 1 1
[email protected] 1 2
[email protected] 2 3
[email protected] 3 1
[email protected] 1 2
[email protected] 2 1
[email protected] 1 2
[email protected] 2 1
[email protected] 1 2
[email protected] 2 1
[email protected] 1 2
[email protected] 2 3
[email protected] 3 4
[email protected] 4 1
[email protected] 1 2
[email protected] 2 1
[email protected] 1 1


Any thoughts on how to fix this?

Hi,

Please see the attached file, I have summarized this with the help of a pivot table.

Or, if you want to use formula to find out the duplicates and delete the whole rows by filtering them, see the attached file.