Here’s a simple example explaining how the new SORT array function works. Columns A and B in the screenshot below (cells A3:B17) contain unsorted sales data by state. To sort these data using a ...

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.

You already know how the SORT() function works; in this case, it serves as the INDEX() function’s array argument. SEQUENCE(I2) is the row_number argument and returns 3 because the input value in ...

As you can see in the screenshot below, the same UNIQUE formula is entered in cell E2, including defining the same array (B2:B101). All that was to be done additionally was to add parentheses around ...