CODEWITHSUNDEEP
excelduplicates
Joran Den Houting
Joran Den Houting

Reputation: 3163

Find duplicates in column 1 and remove column 1 and two

The problem

My table looks like this:

Email               | Name
[email protected]    | Test
[email protected]    | Lorum
[email protected]    | Ipsum
[email protected]     | Bot

Now, I want to find the duplicates in column 1 called Email and then remove all duplicates except the first entry, so the output has to be:

Email               | Name
[email protected]    | Test
[email protected]    | Lorum
[email protected]     | Bot

What I've tried

I added a new row with the this:

=COUNTIF(A:A, A1);

This will add the number of duplicates in the third column, then I remove all the duplicates manually, which takes too much time to do everyday..

The question

Can anyone point me in a good direction to do it in a quick way? Is their an easy solution based on a VB script or something? Or maybe a hidden feature in Excel?

Upvotes: 0

Views: 139

Answers (1)

Amber
Amber

Reputation: 810

In Excel 2010 (I think also 2007) You can remove duplicates by selecting all the data, going to the 'Data' tab in the menu, and then pressing 'Remove Duplicates'

Make sure you only have the 'Email' box ticked as column, and press OK.

This will keep the first (Highest in the list) entry of the email, and erase the whole row of the duplicates after.

Upvotes: 2

Related Questions