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.
-
Recent Posts
Categories
Archives
How to use Excel to compare two versions of a legal contract
This entry was posted in data analysis. Bookmark the permalink.
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!
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.
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!
I love learning formulas for non-math uses. Keep them coming.
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?
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.