As an enhancement to Excel’s calculation engine, the Dynamic Arrays functionality enables a single formula to produce results that expand into other cells, as demonstrated in the SORT example below.

An curved arrow pointing right. {} These brackets mean something magical is happening inside your Excel formula. An "Array" function allows you to perform mathematical operations on many cells ...

In Microsoft Excel, spilled array formulas cannot spill into merged cells. Unmerge the cells, or move the formula to another range that does not interconnect with merged cells.

Creating a list of duplicate values that’s separate from the data source is easier than ever thanks to Microsoft Excel's FILTER() function.

The formula sorts Personnel with the rest of the values and you won’t want that to happen. The simple cure is to remove the header cell from the array range as follows: =SORT (UNIQUE (D3:D13 ...

Array: An array, an array formula, or a reference to range of cells to which you want the number of rows. How to use the ROW function in Microsoft Excel Launch Microsoft Excel. Type into the cell ...

If you want to link multiple cells from another worksheet, you can use an array function, which lets you link a range of cells using one formula.