If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
See responses to your identical post in microsoft.public.excel
(Pl do not multi-post) -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik atyahoodotcom ---- "cpetta" wrote in message ... 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 | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel File in Use Notification Missing?? | JoD317 | General Discussion | 6 | April 19th, 2005 02:33 PM |
How do i copy columns of data in notepad into microsoft excel? | JP | New Users | 2 | February 10th, 2005 09:47 PM |
compare massive values of data in excel | Need help :( | Worksheet Functions | 1 | September 2nd, 2004 01:26 PM |
Coverting Lotus 123 files to use with excel | Muffin1947 | General Discussion | 6 | June 20th, 2004 10:18 AM |