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

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

--
Gary''s Student - gsnu200903


"dberger16" wrote:

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