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.
-
Search It!
-
Recent Entries
- I’ve moved!
- Structured references and tables in Excel
- How to use Excel to compare two versions of a legal contract
- How to write a fundraising letter and evaluate its performance
- A Head First chapter goes from nothing to something
- What kind of modeler are you?
- How to learn a new language… the weird way
- How to sell capacity investments to nonprofits
- Four ways that writing Head First has blown my mind
- Here comes Head First Data Analysis
-
Links
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!