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