ORDENARPOR

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

Sintaxis

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

Intervalo: la matriz o el intervalo que se debe ordenar.

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.

Es posible omitir cualquiera de los argumentos opcionales. Un argumento opcional requiere que todos los separadores precedentes estén presentes.

Ejemplos

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

Información técnica

Esta función está disponible desde la versión 24.8 de LibreOffice.

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

SORTBY wiki page.

SORT