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. Continue reading →