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:


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



Participate now!

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