LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
cpetta
 
Posts: n/a
Default Excel Compare values in columns & display missing values in a new

How can I compare a master part numbers list in one Excel column or worksheet
against actual values in a second Excel column or worksheet, and display the
missing part numbers that were not in the second column in a new column or
worksheet?

For Example:
Part Number Master Part List Missing Parts
12A221315 12A221315 12A221332
12A221316 12A221316 12A221333
12A221317 12A221317
12A221318 12A221318
12A221319 12A221319
12A221320 12A221320
12A221321 12A221321
12A221322 12A221322
12A221323 12A221323
12A221324 12A221324
12A221325 12A221325
12A221326 12A221326
12A221327 12A221327
12A221328 12A221328
12A221329 12A221329
12A221330 12A221330
12A221331 12A221331
12A221316 12A221332
12A221315 12A221333


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Exported Data to excel appearing wrong in Columns lwreece Excel Discussion (Misc queries) 4 March 10th 05 11:03 PM
Excel workbook fails to display when selecting from my documents. 4jjgolly Excel Worksheet Functions 1 March 9th 05 12:48 AM
How do you display the values of variables within an Excel formula curious one Excel Discussion (Misc queries) 1 March 3rd 05 02:52 PM
Add more lines and more columns in Excel Marc Charbonneau Excel Worksheet Functions 3 January 20th 05 03:44 AM
how to increase maximum number of columns in excel 2003 [email protected] Excel Discussion (Misc queries) 1 January 16th 05 08:13 PM


All times are GMT +1. The time now is 02:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"