remove all duplicate records

D

dberger16

Is there a way to remove the duplicate record(s) and the original record at
the same time in a worksheet? Thanks.
 
G

Gary''s Student

Say we have records in column A from A2 thru A100. In B2 enter:
=COUNTIF(A$2:A$100,A2) and copy down. For example:

animal spec
dog 2
cat 1
rat 1
hat 1
bat 2
bat 2
dog 2

Next set an AutoFilter on column B and filter:
Custom... > Not equals > 1

Then delete the visible rows (they will have blue row numbers). Then remove
the AutoFilter to reveal:

animal spec
cat 1
rat 1
hat 1
 
Top