Dynamic Array Functions

FILTER(2019) The array of data in a range that satisfies multiple conditions.
RANDARRAY(2019) The array of random numbers between 0 and 1.
SEQUENCE(2019) The array of sequential numbers.
SINGLE(2019) The value from a cell range which is the intersection of a row OR a column.
SORT(2019) The array of data in a range that has been sorted.
SORTBY(2019) The array of data in a range that has been sorted and satisfies multiple conditions.
UNIQUE(2019) The array of unique values in a list, table or cell range.
FILTER
(2019) The array of data in a range that satisfies multiple conditions.
RANDARRAY
(2019) The array of random numbers between 0 and 1.
SEQUENCE
(2019) The array of sequential numbers.
SINGLE
(2019) The value from a cell range which is the intersection of a row OR a column.
SORT
(2019) The array of data in a range that has been sorted.
SORTBY
(2019) The array of data in a range that has been sorted and satisfies multiple conditions.
UNIQUE
(2019) The array of unique values in a list, table or cell range.

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