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