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.

The syntax for the INDEX function is: INDEX(array, row_num, [column_num]). The array is the range of cells that you’re working with. Row_num is, obviously, the row number in the range that ...

The syntax for the new SORT function is =SORT(array, [sort_index], [sort_order], [by_column]). The first argument identifies the array to be sorted. All the other arguments are optional. The second ...

Figure A We’ll use three functions: SORT(), SEQUENCE() and INDEX(). The first two are dynamic array functions and fairly new to Microsoft 365. INDEX() has been around for a long time ...

though it's two functions used in concert with one another. First let's look at INDEX. With INDEX, you select an array, and then tell it a number, and INDEX returns that element. So here ...