how to compare 2 excel file?

    i have 2 excel file


    file1
    fieldA fieldB fieldC fieldD


    file2
    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?


    thx

    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!

Register Yourself Login