Forum Discussion
Delete repeating records.
Hello! I would like to know how I can remove the duplicate data including the main one. that is, leave in the file only the records that are shown only once by default and eliminate all the others t...
Let's say the names are in A2:A1000.
In another column, enter the word Duplicate in row 1, and enter the following formula in row 2:
=COUNTIF($A$2:$A$1000, $A2)>1
Fill down from row 2 to the last row with data (row 1000).
The new column will show TRUE for duplicate records and FALSE for unique ones.
Filter the new column on TRUE.
Delete the visible rows from row 2 down, then remove the filter.