SORTBY

Sorts the contents of a range or array based on the values in a corresponding range or array.

Syntaxe

SORTBY(Range, SortByRange1, SortOrder1[, SortByRange2, SortOrder2,[...]])

Range: The array or range to sort.

SortByRange1, SortByRange2,... : Range 1, range 2,... are the arrays or ranges to sort on.

SortOrder1, SortOrder2,... : Order 1, order 2,... are the orders to use for sorting. 1 for ascending, -1 for descending. Default is ascending.

Příklady

{=SORTBY(A2:C7,A2:A7,1,C2:C7,-1)}

Sort the range A2:C7 based on the first column in ascending order and third column in descending order.

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.SORTBY