Cómo funciona.
SORTBY es una función fundamental de Excel. Sorts a range based on values in a separate range or array. Permite automatizar hojas de cálculo, simplificar fórmulas complejas y analizar datos con total precisión en Microsoft Excel y Google Sheets.
Sintaxis.
Notación Estándar de Excel=SORTBY(array, by_array1, [sort_order1], ...)Argumentos.
A continuación se detallan todos los parámetros aceptados por esta función.
The range to sort and return.
Ejemplo:A2:A5The criteria range to sort by.
Ejemplo:B2:B51 for Ascending (default), -1 for Descending.
Valor por defecto: 1Ejemplo práctico.
Caso de Uso Paso a PasoOrder Roster - Sort Names by Score
Extract only product names, sorted by their revenue column.
| Product | Revenue | Sorted List |
|---|---|---|
| Product A | 120 | — |
| Product B | 500 | — |
| Product C | 310 | — |
=SORTBY(A2:A5, B2:B5, -1)Evaluates SORTBY over the sample table cells, placing the verified output in cell C2.
Generador de fórmula.
Abrir Asistente CompletoPersonaliza los campos de argumento a continuación para generar una fórmula lista para copiar y pegar en tu hoja de cálculo.
=SORTBY()Comportamiento del resultado.
Returns "Product B" based on sample evaluation criteria and active cell references.
Buenas Prácticas
- Can sort by multiple priority levels: =SORTBY(names, department, 1, salary, -1).
Errores Frecuentes
- The by_array must have the exact same number of rows as the target array or #VALUE! occurs.
Compatibilidad de plataforma y versiones.
Matriz verificada con base en los motores de cálculo oficiales de Microsoft Excel y Google Sheets.
In Excel 2019, sort by secondary key in Data > Sort or use multiple RANK calculations.
Introduced in Excel 365 and Excel 2021. Not available in Excel 2019.
Supported in Google Sheets (uses SORTN or standard SORT with external array keys).
Preguntas frecuentes.
Dudas TécnicasCan I use SORTBY across different worksheets in Excel?↓
Yes. You can reference cells located on other sheets by including the sheet name followed by an exclamation mark, for example: =SORTBY(Sheet2!A2:A10). If the sheet name contains spaces, enclose it in single quotes: ='Q1 Report'!A2:A10.
What is the most common reason for errors in SORTBY?↓
The by_array must have the exact same number of rows as the target array or #VALUE! occurs.
Does SORTBY work identically in Google Sheets?↓
Yes, SORTBY is supported in both Microsoft Excel and Google Sheets with standard evaluation behavior.