Tips for Using ARRAY Formulas and Functions in Excel

ARRAY Formulas and Functions are very powerful. However, they do take a little bit of time to understand.

In fact, several of my viewers have asked me to break-down the concept and steps to take for ARRAYS. One, typical, comment was, "Danny, I just cannot get my head around this concept- Help me!"

In this tutorial, I break down the key concepts of: 1) Fist, selecting all cells to receive results of Array Formula 2) Selecting Arrays that have "matching dimensions" - equal number of Rows & Columns. 3) Using Ctrl + Shift + Enter to complete the Array Formula or Fuction.

I invite you to visit my new online secure shopping cart at:

Danny Rocks
The Company Rocks

[krismaly]

I love this video
Especially host displays Key Points to remember

The host explains the functionality clearly and crisply

Thanks for educating the community

Learned something for the day

[Gasi]

thanks for the POINTS TO REMEMBER. I am just starting to use arrays; i will now also check your videos on other excel tutorials. thanks!!!

[cyhan]

Great tutorial. Your clear explanation makes tricky topic easy to understand. Thank you very much.

[debdeelie]

You're a great teacher! Thank you! God Bless!

[GabiRav]

Very good basic explanation.
Can you please add more part with more complicated examples?

[jaisha]

thank you sir for sharing your knowledge

[DannyRocksExcels]

@GabiRav
Thank you for adding your feedback.

For an additional video on ARRAY Formulas - Search my list of YouTube Videos for FREQUENCY Function and also the SUMPRODUCT Function.

If you need specific direction to these videos, send me a Message and I will attach the links directly in my response.

Danny Rocks
The Company Rocks