Compare 4 columns & find dissimilar

Discussion in 'Excel' started by Bvclsaaal, Jul 2, 2011.

  1. Bvclsaaal

    Bvclsaaal

    Joined:
    Jul 2, 2011
    Messages:
    6
    Likes Received:
    0
    I have 2 spreadsheets with 2 columns in each that I need to compare. Sheet A has a part and a price column, as does Sheet B. I need to compare the part column in A to B and then the price column in A to B and if the price of the part in A is different than the price of the part in B, I need to calculate the difference in a separate column. Can anyone help?
     
    Bvclsaaal, Jul 2, 2011
    #1
    1. Advertisements

  2. Bvclsaaal

    XLPadawan

    Joined:
    Jun 9, 2016
    Messages:
    32
    Likes Received:
    5
    Location:
    Allen, TX
    Upload spreadsheets A & B and I'll do it. I'd rather not have to spend more time setting up the problem than it'll take me to solve it. I've spent most of my day creating sample data and using it to solve problems that have been posed. I could have helped several more people if everyone had uploaded sample files with sample data. Not only that, but it makes the problem a lot easier to understand.
    Thanks!
     
    XLPadawan, Jun 15, 2016
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. tskelton75
    Replies:
    0
    Views:
    607
    tskelton75
    Nov 16, 2011
  2. tskelton75
    Replies:
    0
    Views:
    246
    tskelton75
    Nov 16, 2011
  3. CarolB
    Replies:
    2
    Views:
    923
    XLPadawan
    Jun 15, 2016
  4. David92595
    Replies:
    1
    Views:
    712
    lcaretto
    Jul 25, 2012
  5. hyukfgh
    Replies:
    2
    Views:
    605
    hyukfgh
    Oct 16, 2014
  6. DSnuh
    Replies:
    1
    Views:
    254
    XLPadawan
    Jun 15, 2016
  7. DSnuh
    Replies:
    2
    Views:
    374
    OfficeNewb
    Nov 10, 2015
Loading...