Sorts the contents of a range or array.
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.
Consider the following table
A
B
C
1
Product Name
Sales
Revenue
2
pencil
20
65
3
pen
35
85
4
notebook
20
190
5
book
17
180
6
pencil-case
not
not
{=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
{=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
This function is available since LibreOfficeDev 24.8.
This function is NOT part of the Open Document Format for Office Applications (OpenDocument) Version 1.3. Part 4: Recalculated Formula (OpenFormula) Format standard. The name space is
COM.MICROSOFT.SORT
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4