Results 1 to 2 of 2
  1. #1
    2 Star Lounger bmeacham's Avatar
    Join Date
    Jan 2001
    Austin, Texas, USA
    Thanked 4 Times in 4 Posts

    How 2 compare two files (2002)

    Word has the ability to compare the current document with another file and highlight differences? Does Excel have a similar capability?

    I needed to compare two versions of a spreadsheet. What I ended up doing was to create a second tab in one of the files, copy the other spreadsheet into the second tab, then create a third tab and use the EXACT() function to find differences between cells in the first and second tabs. It worked, but was rather tedious. Is there an easier way?
    Bill Meacham
    bmeacham98 AT

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Thanked 1 Time in 1 Post

    Re: How 2 compare two files (2002)

    You can try the compare.xla add-in available on Chip Pearson's site.
    It compares 2 worksheets and produces a list of differences in a new file.

Posting Permissions

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