SORT

Sorts the contents of a range or array.

note

Enter the formula as an array formula.


Syntaxe

SORT(Range [, SortIndex[, SortOrder[, ByCol]]])

Range: Required. 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.

Příklady

Uvažujme následující tabulku

A

B

C

1

Název zboží

Sales

Revenue

2

nůžky

20

65

3

nůž

35

85

4

poznámkový blok

20

190

5

známka

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


Technické informace

tip

Tato funkce je k dispozici od verze LibreOfficeDev 24.8.


Tato funkce není součástí standardu Open Document Format for Office Applications (OpenDocument) Version 1.3. Part 4: Recalculated Formula (OpenFormula) Format. Její jmenný prostor je

COM.MICROSOFT.SORT