FUNCTION CATALOGUE / LOOKUP & REFERENCE
SORT Excel function
Sorts an array.
Correct sentence to use
Sort [range] by [column number], [ascending or descending].
Modify this query in PlainFormula →Example formula
=SORT(A2:D100,3,-1)
Sorts data by a chosen column or row.
Syntax
SORT(array, [sort_index], [sort_order], [by_col])
Argument signature: array, [sort_index], [sort_order], [by_col]
Availability note
Available in supported Microsoft 365 / newer Excel versions; verify the exact release and platform.