Forum Discussion
office 365 formula classificar
- Obrigado pela ajuda, funcionou, apenas preciso me entender com na fórmula, mas funciona.
I assume you are using the SORT function to return your results. If so, consider wrapping it with the INDEX function.
The following formula returns the first four values returned by SORT in a column. If you want them returned as a row, use commas instead of semicolons in the array constant {1;2;3;4}. Formula 3 using INDICE was produced using the Functions Translator Add-in using my USA formula as input and Portuguese as the output--I hope it has the list separators correct.
=INDEX(SORT(A2:A400,,1),{1;2;3;4})
=ÍNDICE(SORT(A2:A400;;1);{1;2;3;4})
Estou usando a formula classificarpor.
Here is the same approach using SORTBY. Note the use of curly braces surrounding the array constant {1;2;3;4}
=ÍNDEX(SORTBY(A2:A400,B2:B400),{1;2;3;4}) USA Excel
=ÍNDICE(SORTBY(A2:A400;B2:B400);{1;2;3;4}) Portuguese Excel
- entendi, pra mim a formula até funcionou, mas ela so tras a primeira coluna nao esta puxando o resto das informações.
- Excel formulas do not work on "arrays of arrays" at the moment.
But you could copy across a formula that returns the top four in each column like:
=ÍNDEX(SORTBY(A2:A400,$B2:$B400),{1;2;3;4}) USA Excel
=ÍNDICE(SORTBY(A2:A400;$B2:$B400);{1;2;3;4}) Portuguese Excel