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:


Subscribe to my YouTube channel and learn more!

See my free templates here!

Post a comment