Apply array formulas

Apply array formulas

  1. To apply array formulas:
  2. Select the cells in which you want the resultant array (the result of the output formula) to
  3. be present.
  4. Type the array formula you wish to apply over the array. Like other formulas, an array formula is preceded by an "equals" (=) sign.
  5. You may find it comfortable to name the array you plan to use as input by using 'Define Name' feature found in the context menu.
  6. After you enter the formula, press Ctrl + Shift + Enter instead of Enter alone.
  7. The array formula will be executed.