Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
cpetta
 
Posts: n/a
Default 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   Report Post  
Biff
 
Posts: n/a
Default

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   Report Post  
cpetta
 
Posts: n/a
Default

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   Report Post  
Biff
 
Posts: n/a
Default

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   Report Post  
Dave Peterson
 
Posts: n/a
Default

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   Report Post  
Max
 
Posts: n/a
Default

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
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
Excel Compare values in columns & display missing values in a new cpetta Excel Discussion (Misc queries) 1 April 2nd 05 05:51 AM
Formula to compare multiple rows values based on another column? Murph Excel Worksheet Functions 4 February 21st 05 03:44 AM
Compare Columns Michael Nesi Excel Discussion (Misc queries) 1 December 6th 04 09:45 PM
Is this simple I'm trying to compare values from 4 excel tables John Excel Worksheet Functions 1 December 2nd 04 05:00 PM
Need to sum values of columns 1 - 13 and 4 - 15 ExcelHelp Excel Worksheet Functions 1 October 27th 04 07:03 PM


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

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

About Us

"It's about Microsoft Excel"