Deleting duplicate rows

[sean88]

You can use a COUNTIF() formula to test for duplication. In an empty column I would enter this formula and copy down:

=COUNTIF($G$1:$G2,$G2)

Then I would turn on the Data > Filter > Autofilter and do a custom filter on column K for greater than 1.

I would then delete all visible rows, turn off the AutoFilter and clear the added column.

Here's a macro that does it that way:

Please Login or Register  to view this content.

This macro seems like it would delete the duplicate row and the original row it was duplicating. Is that correct?

I would love it if someone can help me delete the duplicates out only but keep 1 record of it.

Eg: Is there a way to keep row 15 but delete row 16 and any other subsequent duplicates?

dupe.PNG

[JBeaucaire]

I can't see the picture you uploaded. If you have another sample dataset, upload that with your before/after explanation.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic