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:
    612
    tskelton75
    Nov 16, 2011
  2. tskelton75
    Replies:
    0
    Views:
    251
    tskelton75
    Nov 16, 2011
  3. CarolB
    Replies:
    2
    Views:
    935
    XLPadawan
    Jun 15, 2016
  4. David92595
    Replies:
    1
    Views:
    715
    lcaretto
    Jul 25, 2012
  5. hyukfgh
    Replies:
    2
    Views:
    609
    hyukfgh
    Oct 16, 2014
  6. DSnuh
    Replies:
    1
    Views:
    275
    XLPadawan
    Jun 15, 2016
  7. DSnuh
    Replies:
    2
    Views:
    380
    OfficeNewb
    Nov 10, 2015
Loading...