Excel Forum



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.