Formulas That Return an Array Result

You can also create array formulas that return an array of different values in a selected range of cells. Formulas that operate on matrices, described in Chapter 9, are examples of formulas that return an array. 

To use a worksheet formula that returns an array result, you must first select a suitable range of cells, with dimensions (R x C) large enough to accommodate the returned array, then type the formula in the formula bar, and finally enter the formula by pressing CONTROL+SHIFT+ENTER. Excel will indicate that the formula is an array formula by enclosing it in braces and will enter the array formula in all the selected cells. 

A few of Excel s worksheet functions are array functions, that is, they return arrays as results. One of these, the LINES statistical function, is described in Chapter 11. 

---