Home |
Search |
Today's Posts |
#1
|
|||
|
|||
I want to delete duplicate rows of similar info and use the lates.
I am trying to paste new data into a workbook that may already contain the
it. I need to filter out the old data and insert or keep the new. The new data is not in the same order as the old. Is there a filter or something that will find a duplicate and give me the option of which row I want to delete? |
#2
|
|||
|
|||
Add the new data to the old data, and go to
data/filter/advanced filter and select "unique records only". This will show you unique records of both the old and new data. Then copy these unique records into a new file. Hope this helped. -----Original Message----- I am trying to paste new data into a workbook that may already contain the it. I need to filter out the old data and insert or keep the new. The new data is not in the same order as the old. Is there a filter or something that will find a duplicate and give me the option of which row I want to delete? . |
#3
|
|||
|
|||
How would you be able to differentiate between old and new data if it were
able to give you the choice - What field would tell you which is which? -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "jsawyer" wrote in message ... I am trying to paste new data into a workbook that may already contain the it. I need to filter out the old data and insert or keep the new. The new data is not in the same order as the old. Is there a filter or something that will find a duplicate and give me the option of which row I want to delete? |
#4
|
|||
|
|||
There is a blank cell in the first row of the New Data.
"Ken Wright" wrote: How would you be able to differentiate between old and new data if it were able to give you the choice - What field would tell you which is which? -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "jsawyer" wrote in message ... I am trying to paste new data into a workbook that may already contain the it. I need to filter out the old data and insert or keep the new. The new data is not in the same order as the old. Is there a filter or something that will find a duplicate and give me the option of which row I want to delete? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find duplicate rows then deleting them | Excel Worksheet Functions | |||
How to delete duplicate rows in Excel 2000? | Excel Discussion (Misc queries) | |||
I want to delete rows with duplicate entries within one column. | Excel Discussion (Misc queries) | |||
How to delete duplicate records when I merge two lists (deleting . | Excel Worksheet Functions | |||
Duplicate Rows | Excel Worksheet Functions |