Sort by one column

The SORT function requires very little configuration. In the example shown, we want to sort data in B5:D14 by the third column, Group. For array, we provide entire range, B5:D14. For sort_index, we provide 3:

=SORT(B5:D14,3)

With this formula in F5, the SORT function outputs the sorted array in F5:H14.

Ascending vs. Descending

Data is sorted in ascending order (A-Z) by default. This behavior is controlled by an optional third argument, sort_order. The default value for sort_order is 1, so both formulas below return the same result as shown in the example above:

=SORT(B5:D14,3)
=SORT(B5:D14,3,1)

To sort in descending (Z-A) order, set sort_order to -1. In the example below, we are sorting data in descending order by score, which is the second column:

=SORT(B5:D14,2,-1)