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:
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.
Away from Excel I enjoy learning Spanish, playing Chess, hanging out with Cali and Fenton and reading Excel books 🙂