In support of this Post
http://www.excelfox.com/forum/showth...0771#post10771

Using Excel 2007 32 bit
Row\Col
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
1
Original Original Original Original Original Original Test Output Test Output Test Output Test Output Test Output NEW NEW NEW NEW NEW NEW
2
Assembly #: Assembly Name: Assembly #: Assembly Name:
3
Qty Per Ref/Designator Description Customer PN Internal PN Manufacture PN Qty Per Ref/Designator Description Customer PN Internal PN Manufacture PN
4
1
Nu Torque ABC
456
456
ABC < > 13456
1
Nu Torque
13456
456
456
5
1
Blu Origin Spaceship
457
457
1
Blu Origin Spaceship
457
457
6
2
Jet Blue21 ABC
458
458
2
New: Jet Blue23 ABC New: DEF New: DEF
2
Jet Blue23 ABC DEF DEF
7
3
EXCELL123
123
ABC ABC
3
EXCELL123
123
ABC ABC
8
3
Toyota Supra
460
460
3
Toyota Supra
460
460
9
2
Emirate ABC12345
461
461
2
Emirate ABC12345
461
461
10
1
Angel ABC12346
462
462
MISSING: 1 MISSING: Angel MISSING: ABC12346 MISSING: 462 MISSING: 462
2
Jet Blue21 ABC
458
458
Worksheet: Result Wanted




Using Excel 2007 32 bit
1
Nu Torque ABC
456
456
ABC < > 13456
1
Nu Torque
13456
456
456
1
Blu Origin Spaceship
457
457
1
Blu Origin Spaceship
457
457
2
Jet Blue21 ABC
458
458
2
New: Jet Blue23 ABC New: DEF New: DEF
2
Jet Blue23 ABC DEF DEF
3
EXCELL123
123
ABC ABC
3
EXCELL123
123
ABC ABC
3
Toyota Supra
460
460
3
Toyota Supra
460
460
2
Emirate ABC12345
461
461
2
Emirate ABC12345
461
461
1
Angel ABC12346
462
462
MISSING: 1 MISSING: Angel MISSING: ABC12346 MISSING: 462 MISSING: 462
2
Jet Blue21 ABC
458
458
Worksheet: Result Wanted