Explanation

The SORT function requires very little configuration.

Forarray, we provide entire range, B5:D14.

Ascending vs.

Example - sort by one column in descending order

Descending

Data is sorted in ascending order (A-Z) by default.

This behavior is controlled by an optional third argument,sort_order.

Values can be sorted by one or more columns.

Example - sort by one column in descending order

SORT returns a dynamic array of results.

Example - sort by one column in descending order

Example - sort by one column in descending order

Example - sort by one column in descending order

Excel SORT function

Example - sort by one column in descending order