Excel currently has 7 new dynamic array functions with more on the way. Microsoft just announced a new feature for Excel that will change the way we work with formulas. That will break the array formula and often but not always an error will be returned.
An array formula one that spans multiple cells can do calculations on rows and columns of cells where you might otherwise need to use several formulas.
Select the expanded range that you want to write to. New and old array formulas In Dynamic Excel there is no need to enter array formulas with control shift enter. To edit the contents of an array formula follow these steps. The reason is that after typing an array formula into an Excel cell you must press Ctrl Shift Enter instead of just Enter.