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.

Sorting is one of Microsoft Excel's easiest tasks. Click; you're done! At least until you need to sort by multiple columns. For this sort task, you'll need a custom sort. Here's how.

To sort by multiple fields (called sorting keys), repeat steps 3 and 4, then click the Add Level button and choose another field (under Column) from the drop-down list in the Then By field. Select ...