How to use Excel to compare two versions of a legal contract

by michael on December 3, 2009

I had a chance to use Excel for this purpose and thought you might want to see the technique.

Be sure to watch it on full screen HD.

  • http://www.supportanalytics.com Tony Rose

    Michael – I know with Excel there is typically 10 different ways to get the same answer. One tip – you can use the formula, =A1=B1 to get the same result as the =exact formula. Regardless, I would definitely go with the if formula to hide results that are true and use conditional formatting.
    Nice tip, thanks for sharing!

    • http://michaelmilton.wordpress.com/ michaelmilton

      Ah, well, if we’re going to split hairs about it, I’d point out that the “=” is not case-sensitive, while EXACT is. :-) Thank you for your comment.

      • excel

         Change-Pro for Excel enables business users to compare two Excel documents for changes.
        With Change-Pro for Excel’ s patent-pending technology, you can view changes made to Excel values and Excel formulas,
        along with comparing row and column changes in spreadsheets.

        excel compare

  • http://www.supportanalytics.com Tony Rose

    It’s good to note that. While you would think that “=” would use the exact function, case sensitive may be important to compare. Good point!

  • Norma Hair

    I love learning formulas for non-math uses. Keep them coming.

  • Tim Stone

    this is a useful reminder. a very quick way of getting to the ‘FALSE’ rows would be to add an Auto-Filter.

    BTW – why wouldn’t you want to use Word for this task?

    • michaelmilton

      thanks for the comment! i can’t think of any reason why you wouldn’t use word, if that was your preference. there are a bunch of ways to skin this cat.

Previous post:

Next post: