D dberger16 Sep 17, 2009 #1 Is there a way to remove the duplicate record(s) and the original record at the same time in a worksheet? Thanks.
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 Sep 17, 2009 #2 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
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
