Comparing two similar spreadsheets

    I have two spreadsheets one an updated version of the other. I need to compare to see the changes. Does excel have a feature that will allow you to view the differences similar to the Diff command in UNIX or the compare feature in Text Pad Pro?

    Re: Comparing two similar spreadsheets


    I'm not sure it's got a built in function, but you can compare them by using a third sheet. In the third sheet, put this formula in cell A1:


    =IF(Sheet1!A1<>Sheet2!A1,"Difference","")


    Then copy it over the range required - "Difference" will be displayed in the cells that differ between sheet1 and sheet2.


    Cheers,


    Jim

Participate now!

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

Register Yourself Login