11
Apr 2013

- BY Kevin Lehrbass
- POSTED IN Formulas
- WITH 0 COMMENTS
- PERMALINK
- STANDARD POST TYPE

**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?**

**In depth array formula posts (grab a cup of coffee!)**

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/**