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.
- Interesting add-in. My guess is that 1 will create a column with English settings, whilst 3 will produce a row with Portuguese settings.
