Excel Forum
Similar Content
Guide to Combine and Consolidate Data in Excel
Tutorial: Guide to combining and consolidating data in Excel. This includes consolidating data from ...
Macro to add a New Line to Message Box Pop-up Windows in Excel
Macro: This is a very simple Message Box, pop-up window, macro for Excel that illustrates how to ...
Combine Multiple Chart Types in Excel to Make Powerful Charts
Tutorial: In this tutorial I am going to show you how to combine multiple chart types to create a si...

Excel Magic Trick #179: Are All Four Word The Same?

Determine whether four words in four cells are exactly the same (case sensitive). Use the IF, AND and EXACT functions in 2 different formulas:
A long IF formula
A short array formula.
Check to see whether More than 2 two words are exactly the same (case sensitive).
Compare Four 4 text strings to determine whether they are equivalent (exactly the same).

Got a Question? Ask it Here in the Forum.