Dynamic Array Formulas
Also known as Spilled Array Formulas
Added in Microsoft 365 / 2020
link - https://support.office.com/en-gb/article/dynamic-array-formulas-in-non-dynamic-aware-excel-696e164e-306b-4282-ae9d-aa88f5502fa2
link - https://support.office.com/en-us/article/dynamic-array-formulas-vs-legacy-cse-array-formulas-ca421f1b-fbb2-4c99-9924-df571bd4f1b4
link - https://templates.office.com/en-gb/dynamic-array-formulas-tutorial-tm67741002
The following functions can all return a dynamic array formula.
| FILTER | (Microsoft 365) The array of data in a range that satisfies multiple conditions. |
| MUNIT | (2013) The unit matrix or the specified dimension. |
| OFFSET | The value in a cell which is an offset from another cell. |
| RANDARRAY | (Microsoft 365) The array of random numbers between 0 and 1. |
| SEQUENCE | (Microsoft 365) The array of sequential numbers. |
| SORT | (Microsoft 365) The array of data in a range that has been sorted. |
| SORTBY | (Microsoft 365) The array of data in a range that has been sorted based on the values in a corresponding range. |
| UNIQUE | (Microsoft 365) The array of unique values in a list, table or cell range. |
| FILTER (Microsoft 365) The array of data in a range that satisfies multiple conditions. |
| MUNIT (2013) The unit matrix or the specified dimension. |
| OFFSET The value in a cell which is an offset from another cell. |
| RANDARRAY (Microsoft 365) The array of random numbers between 0 and 1. |
| SEQUENCE (Microsoft 365) The array of sequential numbers. |
| SORT (Microsoft 365) The array of data in a range that has been sorted. |
| SORTBY (Microsoft 365) The array of data in a range that has been sorted based on the values in a corresponding range. |
| UNIQUE (Microsoft 365) The array of unique values in a list, table or cell range. |
© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited TopPrevNext