Results 1 to 2 of 2

Thread: How to compare data in Excel 2010

  1. #1

    How to compare data in Excel 2010



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi everyone.

    I have some data I need to compare in Excel 2010.

    It looks something like this:

    1 2 1 2 1 2
    1 2 1 5 1 2
    1 2 1 2 1 2
    1 8 1 2 9 2
    1 2 1 2 1 2
    1 2 4 2 1 2
    1 2 1 2 1 2

    and it needs to be compared with:

    1 2
    1 2
    1 2
    1 2
    1 2
    1 2
    1 2

    These same two columns should be used to compare all 6 columns in the first piece of data. The 1 columns should be compared and the 2 columns should be compared.

    As an output I need a list of all cells that don't match what they are being compared with.

    Any suggestions on how I might achieve this?

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,499
    Articles
    0
    Excel Version
    Excel 2016


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •