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.

In newer versions of Excel, array formulas automatically expand to fit the space needed for the formula to work. This is called the spill range. In a spill range, other related cells that do not ...

Excel running totals made easy with dynamic arrays. Explore advanced functions for accurate, flexible data handling and improved performance.

Microsoft Excel's new dynamic array functions make complex calculations easier than ever before.

Excel has SumIf and CountIf, but no AverageIf. However, with a little array magic, you can get Excel to average values, conditionally.

If you see You can't change part of an array error while trying to use the Sort, Delete, Edit, or some other feature in Microsoft Excel, see this post.