We've added six new dynamic array functions that automatically spill results into multiple cells.
-
The FILTER function lets you filter using a formula — a popular request from our customers.
-
The SORT function allows you to sort a range or array.
-
The SORTBY function enables you to sort based on a corresponding range or array.
-
The UNIQUE function returns a distinct list of values without any duplicates.
-
The SEQUENCE function generates a sequence of numbers across multiple cells.
-
The RANDARRAY function creates random numbers across multiple cells.
