Question: Why use an array formula?

Answer: You can answer a complex question using only 1 array.


In this video, the array uses the EXACT and LEFT worksheet functions.

If you don’t know what array formulas are then you should learn as array formulas can transform the way that you use Microsoft Excel.


Watch my YouTube video


Confused? Watch this Array Intro video


Subscribe to my YouTube channel and learn more!

See my free templates here!

Post a comment