Delete duplicate rows
 

I need some help. I have been given several spreadsheets
with duplicate data on them - eg part number, value, qty
per.

I am trying to get a clean list of data that can be used
as a lookup table in the future. However, there are
duplicates on the spreadsheets and I want to take out
only those duplicates that match by cells exactly.

EG..
X20BO871 Male Br 501 M41037 Insert 0.062 1
X20BO871 Male Br 501 M41037 Insert 0.062 1

Other examples are(where I want to make the decision as
to which one to take out):

X20BO876 "O" Ring 43.4mmID by 3.6 0.064 100
X20BO876 "O" Ring 43.4mmID by 3.6 0 100

There are thousands of lines, so any help would be
greatly appreciated

Delete duplicate rows
 

Just use the data/advanced filter and copy to a new
location, selecting the Unique items only check box.

Patrick Molloy
Microsoft Excel MVP

-----Original Message-----
I need some help. I have been given several
spreadsheets
with duplicate data on them - eg part number, value, qty
per.

I am trying to get a clean list of data that can be used
as a lookup table in the future. However, there are
duplicates on the spreadsheets and I want to take out
only those duplicates that match by cells exactly.

EG..
X20BO871 Male Br 501 M41037 Insert 0.062 1
X20BO871 Male Br 501 M41037 Insert 0.062 1

Other examples are(where I want to make the decision as
to which one to take out):

X20BO876 "O" Ring 43.4mmID by 3.6 0.064 100
X20BO876 "O" Ring 43.4mmID by 3.6 0 100

There are thousands of lines, so any help would be
greatly appreciated


.