Explanation
The SORT function requires very little configuration.
Forarray, we provide entire range, B5:D14.
Ascending vs.
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.
SORT returns a dynamic array of results.