Video 00042 Why would I need an array formula?

Deprecated: File class-oembed.php is deprecated since version 5.3.0! Use wp-includes/class-wp-oembed.php instead. in /nas/content/live/spreadsheetdev/wp-includes/functions.php on line 6078

Notice: Undefined property: stdClass::$height in /nas/content/live/spreadsheetdev/wp-content/plugins/embedplus-for-wordpress/embedplus.php on line 251

Why would I need an array formula?

I have heard this question so many times over the years! If you have never ever used an array formula than this video is for you.

Don’t worry….No prior knowledge is required. I explain things slowly.


This video starts by explaining reasons why an array formula would be necessary.

Then, I explain how a formula helper column can sometimes be used to avoid using an array formula.

Next, I show you several examples of what array formulas can do. If you work a lot with data, array formulas can be extremely helpful.


Watch my YouTube video


Do you want to learn more?

If you prefer to read about array formulas I suggest these links:


Subscribe to my YouTube channel and learn more!


About Me

My name is Kevin Lehrbass. I live in Markham, Ontario, Canada.  I’ve been studying, supporting, building, troubleshooting, teaching and dreaming in Excel since 2001. I’m a Data Analyst.

There are so many amazing things that you can do with this powerful software. Check out my videos and my blog posts.

Away from Excel I enjoy learning Spanish, playing Chess, hanging out with Cali and Fenton and reading Excel books 🙂

Leave a Reply

Your email address will not be published. Required fields are marked *