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:
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:
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: