SORT

Sorts the contents of a range or array.

note

Enter the formula as an array formula.


Sintassi

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.

Esempi

Considerate la tabella seguente

A

B

C

1

Nome prodotto

Sales

Revenue

2

matita

20

65

3

penna

35

85

4

notebook

20

190

5

libro

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


Informazioni tecniche

tip

This function is available since LibreOfficeDev 24.8.


Questa funzione non fa parte dello standard Open Document Format for Office Applications (OpenDocument) Version 1.3. Part 4: Recalculated Formula (OpenFormula) Format. Lo spazio dei nomi รจ

COM.MICROSOFT.SORT