Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
delete duplicate rows, keep one | Excel Discussion (Misc queries) | |||
Delete rows with duplicate values | Excel Discussion (Misc queries) | |||
delete duplicate rows | Excel Worksheet Functions | |||
Delete rows with duplicate values | Excel Worksheet Functions | |||
delete duplicate rows | Excel Programming |