how to compare 2 excel file?

  • i have 2 excel file

    fieldA fieldB fieldC fieldD

    columnA columnB columnC columnD

    each file contain around 300 row and impossible to check using side by side view

    is there any formula to make it easy?
    i.e open file1 and read file2 from file 1 using formulas?


  • Re: how to compare 2 excel file?

    Hi 03042015, welcome to OzGrid

    =A1='[Other workbook name]Other sheet'!A1

    Obviously you will need to replace "Other workbook name" and "Other sheet" with the correct names, and change "A1" to the actual data you're trying to compare.

    This will return TRUE if the data matches, and FALSE if not.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!