Look Who it Was Random video

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

4,468 views · Published 3 January 2009 · 4:50 · Indexed 31 October 2026

Channel: excelisfun · 2009 · Science & Technology

Watch on YouTube

Download Excel Start File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT175-184.xls
Download Excel Finished File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT175-184Finished.xls
Full Page With All File Links: http://people.highline.edu/mgirvin/excelisfun.htm

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).

More from this channel