What is an array formula?
February 3, 2012 1 Comment
Array formula often provide a shortcut or more efficient approach to performing complex calculations in Google Spread sheets. An array formula can return a result in either one cell or in a range of cells. Array formula perform operations on two or more sets of values, called array argument. Each array argument used in an array formula must contain exactly the same number of rows and columns.
When entering an array formula, the first function will be arrayformula and then select the formulas which you want Google Spread sheet to place the array formula. Or otherwise you can write the formula followed by Control+Shift+Enter(window) or Command+Shift+Enter (Mac) google docs will automatically put entire formula in side arrayformula.
To understand arrayformula’s visit the Google Docs forum at the following link