1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Compare 2 excel files

Discussion in 'Ask an Excel Question' started by aksusa, Aug 11, 2011.

  1. aksusa

    aksusa New Member

    Messages:
    9
    Guys-


    I need your help to compare 2 excel files


    Excel File-1 (Sheet1)


    Machine Class Instance Parameter RemedyGroup

    servername FS /ora FSCapacity ETD

    servername1 FS /ora1 FSCapacity ETD1

    servername2 FS /ora2 FSCapacity ETD2

    servername3 FS /ora FSCapacity ETD

    servername FS /ora3 FSCapacity ETD3


    Excel File-2 (Sheet1)

    Delete Machine Class Instance Parameter RemedyGroup

    yes servername1 FS /ora1 FSCapacity ETD1

    yes servername FS /ora FSCapacity ETD

    yes servername2 FS /ora2 FSCapacity ETD2

    yes servername FS /ora FSCapacity ETD


    I need to compare Excel File-1 with Excel File-2 for columns Machine | Instance | Remedygroup. For example servername is in Excel File-1 with values of /ora and Remedy Group of ETD and if it is matching then highlight in Green color in Excel File-1 .. if not red color
  2. Luke M

    Luke M Excel Ninja

    Messages:
    9,383
    Helper column to concatenate fields in both files that need to match:

    =A2&C2&E2

    I'll assume this is col AA for now


    Then, in whichever file you want to compare against other list, something like:

    =ISNUMBER(MATCH(AA2,[OtherFile.xls]Sheet1!AA:AA,0))


    Anything with a TRUE was found in the other list, FALSE indicates no match found.
    Thomas Kuriakose likes this.
  3. aksusa

    aksusa New Member

    Messages:
    9
    Is it possible with a VB script
  4. Luke M

    Luke M Excel Ninja

    Messages:
    9,383
    Sure. Quick and dirty, record a macro of you doing the steps I stated above, filter on true/false, color your cells, and delete contents of helper cells.

Share This Page