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

Ask a Question

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

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.