Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove duplicates from Sheet 2
Hi everyone,
I have 2 sheets containing data Sheet 1 A1-AT623 and Sheet 2 A1-AF822. Where I already have data in Sheet 1 I would like to be able to delete (or extract to a 3rd sheet) that row in Sheet 2. If anyone could help that would be fantastic! Cheers Diddy |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove duplicates from Sheet 2
Examples and criteria?
-- Don Guillett Microsoft MVP Excel SalesAid Software "Diddy" wrote in message ... Hi everyone, I have 2 sheets containing data Sheet 1 A1-AT623 and Sheet 2 A1-AF822. Where I already have data in Sheet 1 I would like to be able to delete (or extract to a 3rd sheet) that row in Sheet 2. If anyone could help that would be fantastic! Cheers Diddy |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove duplicates from Sheet 2
Sorry meant to say :-(
The value on which to look for duplicates is in C in both sheets and is a string 12-14 long with letters and numbers. e.g. F200797863807A Many thanks Diddy "Don Guillett" wrote: Examples and criteria? -- Don Guillett Microsoft MVP Excel SalesAid Software "Diddy" wrote in message ... Hi everyone, I have 2 sheets containing data Sheet 1 A1-AT623 and Sheet 2 A1-AF822. Where I already have data in Sheet 1 I would like to be able to delete (or extract to a 3rd sheet) that row in Sheet 2. If anyone could help that would be fantastic! Cheers Diddy . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I remove duplicates | Excel Discussion (Misc queries) | |||
remove duplicates | Excel Discussion (Misc queries) | |||
How to remove row duplicates | Excel Discussion (Misc queries) | |||
Remove Duplicates | New Users to Excel | |||
Remove duplicates | Excel Discussion (Misc queries) |