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!

Array formula book

 

Written by Mike Girvin from YouTube channel ExcelIsFun

 

 

 

 

Subscribe to my YouTube channel and learn more!

See my free templates here!

Post a comment