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.