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.

Let’s do an example where we will use the UNIQUE function to create a list of unique customers, as we did above, but let’s incorporate the SORT function to sort the list. Advertisement As you can see ...

To use the function, you simply enter the function name at the sheet level, as you would any of Excel’s built-in functions. That’s all great, but there’s more.

If you don't use headers, your columns will be labeled "A," "B," "C' and so on. Click the "Sort By" drop-down menu, and then click the name of the header of the first list you want to sort in a group.