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:
The Company Rocks