Results 1 to 3 of 3
  1. #1
    5 Star Lounger Ruff_Hi's Avatar
    Join Date
    Feb 2001
    New York, New York, USA
    Thanked 0 Times in 0 Posts

    Compare (Excel XP)

    Good Morning All

    We have a number of spreadsheets that are very similar and / or newer versions of the same spreadsheet. The problem is that sometimes different versions get updated and you want to compare two spreadsheets so that you can see the differences.

    Is there a build in utility in excel to do this?
    Is there an external utility to do this?
    Has anyone written a macro to do this?

    I could write one but I thought that I would check here before I get carried away.
    (Location Australia, then UK, but now USA. Heart, outlook, attitude, etc always Australian)
    Quote: "All Happiness is the release of internal pressure"

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Compare (Excel XP)

    If you do a Google search for excel compare workbooks, you'll find lots of utilities to compare workbooks or worksheets. Several have free trial downloads.

  3. #3
    Super Moderator macropod's Avatar
    Join Date
    May 2002
    Canberra, Australian Capital Territory, Australia
    Thanked 465 Times in 382 Posts

    Re: Compare (Excel XP)

    One simple way would be to open both, plus a third and in the third put a formula in A1 like:
    then copy this formula down/across the range corresponding to the used ranges in the other workbooks.

    Any cells in the third workbook with zero values will then represent cells that differ between the other two.

    To compare numeric differences only, use:
    In this case, differences wil show as non-zero values, with the numbers representing the extent of the differences.


    Paul Edstein
    [MS MVP - Word]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts