Dynamic Array

The definition of a "dynamic array function" is a function that can populate more than one cell.
Exactly how many cells the function populates, can vary, depending on the data passed in. Hence the word "dynamic".
Before Office 365, populating more than one cell using one function, was only possible with Ctrl + Shift + Enter.
In Office 365 you can populate more than one cell using Enter (you don't have to use Ctrl + Shift + Enter) any more.


New Dynamic Array Functions

In Office 365 these new functions can populate more than one cell, by just using Enter.

FILTER(Microsoft 365) Returns an array of data in a range that satisfies multiple conditions.
RANDARRAY(Microsoft 365) Returns an array of random numbers between 0 and 1.
SEQUENCE(Microsoft 365) Returns an array of sequential numbers.
SORT(Microsoft 365) Returns an array of data in a range that has been sorted.
SORTBY(Microsoft 365) Returns an array of data in a range that has been sorted based on the values in a corresponding range.
UNIQUE(Microsoft 365) Returns an array of unique values in a list, table or cell range.
FILTER
(Microsoft 365) Returns an array of data in a range that satisfies multiple conditions.
RANDARRAY
(Microsoft 365) Returns an array of random numbers between 0 and 1.
SEQUENCE
(Microsoft 365) Returns an array of sequential numbers.
SORT
(Microsoft 365) Returns an array of data in a range that has been sorted.
SORTBY
(Microsoft 365) Returns an array of data in a range that has been sorted based on the values in a corresponding range.
UNIQUE
(Microsoft 365) Returns an array of unique values in a list, table or cell range.

*The SINGLE function was deprecated and should not be used.


Existing Functions Have Also Been Upgraded

It has always been possible to use Ctrl + Shift + Enter with certain functions to populate more than one cell.
In Office 365 a lot of the existing functions have also been upgraded so they can ALSO populate more than one cell, by just using Enter.
Before Office 365, the curly brackets were necessary.
In Office 365, the curly brackets have become optional.

SQRTReturns the positive square root of a number.
SQRT
Returns the positive square root of a number.

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