Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
matching 2 worksheets to find differences
Can someone please help me with this task?
I have 2 worksheets I need to match to find entries that don't apprear in the other worksheet. Worksheet3 shows rows from Worksheet1 that don't appear in Worksheet2. Worksheet4 shows rows from Worksheet2 that don't appear in Worksheet1. Example: worksheet1 worksheet2 worksheet3 worksheet4 A B C <= cols = A B C <= cols = A B C <= cols = A B C a b 1 a b 1 a b 2 b n 1 a b 2 a b 3 c h 5 d f 3 a b 3 b n 1 d f 1 c h 3 c h 3 c h 5 c h 7 c h 7 d f 3 d f 1 Thank you, Victor |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to find exact differences between two worksheets | Excel Worksheet Functions | |||
Find differences between two Excel workbooks or worksheets | Excel Discussion (Misc queries) | |||
Find Matching Records in Two Worksheets | Excel Discussion (Misc queries) | |||
Find matching records in two worksheets | Excel Discussion (Misc queries) | |||
How do I find differences between two excel worksheets? | New Users to Excel |