Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() I 'm in dire need of a solution to this problem, I need to match sheet1 to sheet 2 by entire rows and show the non matching rows on sheet3. Any help with this would be greatly appreciated. I've been working this for a week and cannot come up with a solution. Sheet1 Sheet2 Sheet3 1 A Alfa 1.0001 1 A Alfa 1.0021 1 A Alfa 1.0001 2 B Bravo 2.0001 2 B Bravo 2.0001 99 booboo RALPH 99.0001 3 C Charlie 3.0001 3 C Charlie 3.0001 1 A Alfa 1.0021 4 D Delta 4.0001 4 D Delta 4.0001 55 OHNO BOB 55.0001 5 E Echo 5.0001 5 E Echo 5.0001 6 F Foxtrot 6.0001 6 F Foxtrot 6.0001 7 G Golf 7.0001 7 G Golf 7.0001 8 H Hotel 8.0001 8 H Hotel 8.0001 9 I India 9.0001 9 I India 9.0001 10 J Juliet 10.0001 10 J Juliet 10.0001 11 K Kilo 11.0001 55 OHNO BOB 55.0001 12 L Lima 12.0001 11 K Kilo 11.0001 13 M Mike 13.0001 12 L Lima 12.0001 14 N November 14.0001 13 M Mike 13.0001 15 O Oscar 15.0001 14 N November 14.0001 16 P Papa 16.0001 15 O Oscar 15.0001 17 Q Quebec 17.0001 16 P Papa 16.0001 18 R Romeo 18.0001 17 Q Quebec 17.0001 19 S Sierra 19.0001 18 R Romeo 18.0001 20 T Tango 20.0001 19 S Sierra 19.0001 21 U Uniform 21.0001 20 T Tango 20.0001 22 V Victor 22.0001 21 U Uniform 21.0001 23 W Whiskey 23.0001 22 V Victor 22.0001 24 X XRay 24.0001 23 W Whiskey 23.0001 25 Y Yankee 25.0001 24 X XRay 24.0001 26 Z Zulu 26.0001 25 Y Yankee 25.0001 99 booboo RALPH 99.0001 26 Z Zulu 26.0001 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Matching Rows | Excel Discussion (Misc queries) | |||
Column Matching - Bring the entire row. | Excel Discussion (Misc queries) | |||
Return position for each matching value in entire workbook? | Excel Worksheet Functions | |||
Inserting Entire Rows | Excel Programming | |||
Deleting entire rows | Excel Programming |