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:
- http://chandoo.org/wp/2011/01/07/check-sort-order-of-a-list/
- http://www.mrexcel.com/articles/CSE-array-formulas-excel.php
- http://www.cpearson.com/excel/ArrayFormulas.aspx
- http://www.myonlinetraininghub.com/excel-array-formula
- http://www.exceluser.com/explore/arrays1.htm
- http://blog.contextures.com/archives/2011/07/27/finding-min-if-or-max-if-in-excel/
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 🙂