Excel Array Formulas
In Excel, an array formula is a formula that carries out calculations on one or more elements in an array.
An array is range or group of related data values. In a spreadsheet program such as Excel the values in an array are normally stored in adjacent cells.
Array formulas in Excel are surrounded by curly braces "{ } ". These are added to a formula by pressing the CTRL, SHIFT, and ENTER keys after typing the formula into a cell or cells.
For this reason an array formula is sometimes referred to as a CSE formula in Excel.
Types of Array Formulas
There are two types of array formulas - those that are located in multiple cells in a worksheet (multi cell array formula) and those located in a single cell (single cell array formula).
Single Cell Array Formula Tutorial
This step by step tutorial covers creating a single cell array formula in Excel.
Tutorial Topics
