Dynamic Array Formulas


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.
RANDARRAY(Microsoft 365) The array of random numbers between 0 and 1.
SEQUENCE(Microsoft 365) The array of sequential numbers.
SINGLE(Microsoft 365) The value from a cell range which is the intersection of a row OR a column.
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.
RANDARRAY
(Microsoft 365) The array of random numbers between 0 and 1.
SEQUENCE
(Microsoft 365) The array of sequential numbers.
SINGLE
(Microsoft 365) The value from a cell range which is the intersection of a row OR a column.
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.


© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited TopPrevNext