Results 1 to 3 of 3
  1. #1
    5 Star Lounger Ruff_Hi's Avatar
    Join Date
    Feb 2001
    Location
    New York, New York, USA
    Posts
    768
    Thanks
    0
    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
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 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
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 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:
    =([Book1]Sheet1!A1=[Book2]Sheet1!A1)*1
    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:
    =[Book1]Sheet1!A1-[Book2]Sheet1!A1
    In this case, differences wil show as non-zero values, with the numbers representing the extent of the differences.

    Cheers
    Cheers,

    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
  •