Removing duplicate rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to remove entire rows if the cells in a particular column are the same.

I just want to keep one of the rows. I tried "UNIQUE RECORDS" in the
advanced filterin the DATA MENU, but it doesn't seem to work. I still have
all the duplicates.

Jase
 
Say we are interested in column B have have made sure there is a label cell
on the top:

item
dog
dog
hat
bat
hat
spat
bat

we want to drop the rows with duplicate dogs, etc.

In another column, say column C, put a label in C1 and in C2 enter:
1
In C3 enter:
=COUNTIF(B$2:$B3,B3) and copy down

We see:

item counts
dog 1
dog 2
hat 1
bat 1
hat 2
spat 1
bat 2

Use autofilter on column C to view only the 1's (first instance of any
duplicate):

item counts
dog 1
hat 1
bat 1
spat 1

Copy these visible rows and paste elsewhere.
 
Back
Top