Menu
EXCEL SORT FUNCTION
Excel SORT Function Introduction
SORT is a function that sorts the contents of a range or array.
Description of Excel SORT Function
Syntax :
=SORT (array, [sort_index], [sort_order], [by_col])
Parameters :
- array – To sort, use a range or array.
- sort index – [obligatory] Sorting with a column index. The default value is 1.
- sort order – [obsolete] 1 denotes ascending, -1 denotes descending. Ascending order is the default.
- by col – [obligatory] TRUE if you want to sort by column. TRUE if you want to sort by row. The default value is FALSE.
Step By Step Guide of SORT Function
Example :
The SORT function extracts all values and sorts them by score in decreasing order.
Key Points
- this function available in excel version Excel 365.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
