Question: Why use an array formula?
Answer: Because you can answer many complex questions using only 1 array formula!
In this video, I use an array formula to extend the use of Excel’s LEN function.
The LEN function can normally only tell you the length of the contents of a single cell. However, an array formula can use the LEN function to determine the length of a range of cells.
Watch my YouTube video
Confused? Watch this Array Intro video
Buy the only Array formula Book!
Written by Mike Girvin from YouTube channel ExcelIsFun