SORT is one of several new functions that take advantage of Excel’s new Dynamic Arrays functionality, which was recently released as a beta feature to some Office Insiders (see the February 2019 Tech ...

If the function doesn’t return something, the output array will be labeled undefined in that position. To create an array with a different length, you can use Array.filter() .

SORT()’s array argument is the entire FILTER() function. The sort_index value of 2 sorts by the Value column, the second column in array. The sort_index value is -1, which applies a descending sort.

How to use Microsoft 365’s dynamic array function SEQUENCE() to create a list of dates in Excel Your email has been sent Image: PixieMe/Shutterstock Must-read Windows coverage CrowdStrike Outage ...