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 at McKinsey & Company.

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 🙂

Post a comment