Tips for Using ARRAY Formulas and Functions in Excel

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:
http://shop.thecompanyrocks.com

Danny Rocks
The Company Rocks

Leave a Reply

Close Menu