Exceljet

Quick, clean, and to the point

Dynamic Excel

Example of Dynamic Array formula in Excel

In fall 2018, Microsoft announced new functionality in Excel called "dynamic array formulas". Dynamic array formulas have the ability to natively work with multiple values and can "spill" these results onto the worksheet.

The new functionality is provided in two parts:

  1. New functions designed to leverage dynamic array behavior directly
  2. Legacy support that lets older formulas and functions use dynamic arrays.

This is a big upgrade and a radical change to the way Excel behaves in some circumstances, and it is only available for now via the Office 365 version of Excel. This means all other versions of Excel, including 2016 and 2019, do not have dynamic arrays.

Thus, "Dynamic Excel" is just a convenient term to differentiate versions. It simply means the version of Excel that provides dynamic array formulas. We sometimes also use the term "Traditional Excel" to indicate all other versions.

For a quick summary of dynamic arrays, see: Dynamic Array

For details and examples, see: Dynamic Array Formulas in Excel

Dynamic Arrays are only available in Office 365.