SORT

Sorts the contents of a range or array.

Enter the formula as an array formula.

Sintaxi

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.

Exemples

Considereu la taula següent

	A	B	C
1	Nom del producte	Sales	Revenue
2	llapis	20	65
3	ploma	35	85
4	quadern	20	190
5	llibre	17	180
6	estoig	not	not

Exemple amb ordre ascendent

{=SORT(A2:C6,2,1)}

Sort the range A2:C6 based on the second column in ascending order (Sales).

llibre	17	180
llapis	20	65
quadern	20	190
ploma	35	85
estoig	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).

estoig	not	not
quadern	20	190
llibre	17	180
ploma	35	85
llapis	20	65

Informació tècnica

Aquesta funció és disponible des de la versió 24.8 del LibreOffice.

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

SORT wiki page.

SORTBY