SORT
Sorts the contents of a range or array.
Enter the formula as an array formula.
SORT(Range [; SortIndex [; SortOrder [; ByCol] ] ])
Range: the range or array to sort.
SortIndex: (optional). The number indicating the row or column to sort by.
SortOrder: (optional). A number indicating the desired sort order; 1 for ascending order (default), -1 for descending order.
ByCol: (optional). A logical value indicating the desired sort direction; FALSE to sort by row (default), TRUE to sort by column.
Any of the optional arguments can be omitted. An optional argument requires all preceding separators to be present.
Example with ascending order
{=SORT(A2:C6;2;1)}
Sort the range A2:C6 based on the second column in ascending order (Sales).
|
book |
17 |
180 |
|
pencil |
20 |
65 |
|
notebook |
20 |
190 |
|
pen |
35 |
85 |
|
pencil-case |
not |
not |
Example with descending order
{=SORT(A2:C6;3;-1)}
Sort the range A2:C6 based on the third column in descending order (Revenue).
|
pencil-case |
not |
not |
|
notebook |
20 |
190 |
|
book |
17 |
180 |
|
pen |
35 |
85 |
|
pencil |
20 |
65 |
COM.MICROSOFT.SORT
