Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Compare values in columns
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
|
|||
|
|||
Check relpies in your other posts!
Biff -----Original 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 . |
#3
|
|||
|
|||
Which other posts? I am a new user? Can you help direct me?
"Biff" wrote: Check relpies in your other posts! Biff -----Original 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 . |
#4
|
|||
|
|||
Hi!
You've posted: 2 in .Functions 1 in .NewUsers 1 in .Programming 1 in .Misc 1 in .Excel You have replies in .Functions and .Misc Biff -----Original Message----- Which other posts? I am a new user? Can you help direct me? "Biff" wrote: Check relpies in your other posts! Biff -----Original 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 . . |
#5
|
|||
|
|||
Since you're a new user, you may want to read Chip Pearson's notes:
http://www.cpearson.com/excel/newposte.htm cpetta wrote: Which other posts? I am a new user? Can you help direct me? "Biff" wrote: Check relpies in your other posts! Biff -----Original 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 . -- Dave Peterson |
#6
|
|||
|
|||
You have replies in .Functions and .Misc
Correction to above line <g: You have replies in .Functions,.Misc and .Excel -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Compare values in columns & display missing values in a new | Excel Discussion (Misc queries) | |||
Formula to compare multiple rows values based on another column? | Excel Worksheet Functions | |||
Compare Columns | Excel Discussion (Misc queries) | |||
Is this simple I'm trying to compare values from 4 excel tables | Excel Worksheet Functions | |||
Need to sum values of columns 1 - 13 and 4 - 15 | Excel Worksheet Functions |