SORT

Sorts the contents of a range or array.

Enter the formula as an array formula.

Syntaxe

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

Examinez le tableau suivant

	A	B	C
1	Nom du produit	Sales	Revenue
2	crayon	20	65
3	stylo	35	85
4	bloc-notes	20	190
5	livre	17	180
6	pencil-case	not	not

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

Informations techniques

This function is available since LibreOffice 24.8.

Cette fonction ne fait pas partie de Open Document Format for Office Applications (OpenDocument) Version 1.3. Partie 4 : Norme de format de formule recalculée (OpenFormula). L'espace de nom est

COM.MICROSOFT.SORT

SORT wiki page.

SORTBY