SORTBY

αƒ“αƒαƒαƒšαƒαƒ’αƒ”αƒ‘αƒ‘ αƒ¨αƒ£αƒαƒšαƒ”αƒ“αƒ˜αƒ‘ αƒαƒœ αƒ›αƒαƒ‘αƒ˜αƒ•αƒ˜αƒ‘ შემαƒͺαƒ•αƒ”αƒšαƒαƒ‘αƒαƒ‘ αƒ¨αƒ”αƒ‘αƒαƒ‘αƒαƒ›αƒ˜αƒ‘αƒ˜ αƒ¨αƒ£αƒαƒšαƒ”αƒ“αƒ˜αƒ‘ αƒαƒœ αƒ›αƒαƒ‘αƒ˜αƒ•αƒ˜αƒ‘ αƒ›αƒœαƒ˜αƒ¨αƒ•αƒœαƒ”αƒšαƒαƒ‘αƒ”αƒ‘αƒ–αƒ” αƒ“αƒαƒ€αƒ£αƒ«αƒœαƒ”αƒ‘αƒ˜αƒ—.

αƒ‘αƒ˜αƒœαƒ’αƒαƒ₯αƒ‘αƒ˜

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.

note

Any of the optional arguments can be omitted. An optional argument requires all preceding separators to be present.


αƒ›αƒαƒ’αƒαƒšαƒ˜αƒ—αƒ”αƒ‘αƒ˜

{=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.

Technical information

tip

This function is available since LibreOffice 24.8.


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

αƒ“αƒαƒ™αƒαƒ•αƒ¨αƒ˜αƒ αƒ”αƒ‘αƒ£αƒšαƒ˜ αƒ—αƒ”αƒ›αƒ”αƒ‘αƒ˜

tip

SORTBY wiki page.


SORT

Please support us!