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 formula =SORT(A3:B17) uses the default “sort by” and “sort order” settings; thus, the list is sorted in alphabetical order. The syntax for the new SORT function is =SORT(array, [sort_index], [sort ...

With INDEX, you select an array, and then tell it a number, and INDEX returns that element. Walter Hickey / BI So here, INDEX gave us the 2nd element of the B2:B9 array, which is New York.

The INDEX formula doesn’t recognize column letters, so you must use numbers (counting from the left). The syntax for the MATCH function is: MATCH(lookup_value, lookup_array, [match_type]).