CHOOSEROWS
Returns the specified rows from an array.
Introduza a fórmula como fórmula de matriz. Suxestión: Introduza a fórmula empregando as teclas Ctrl + Maiús + Intro.
=CHOOSEROWS(Array; Row_1 [; Row_2 [; Row_3 [; ...]]])
Array: The array containing the rows to be returned in a new array.
Row_1: The index of the first row to be returned. A negative value chooses from the end of the array.
Row_2; Row_3; ...: (optional) The list of other row indexes to be returned. A negative value chooses from the end of the array.
Pódese omitir calquera dos argumentos opcionais. Un argumento opcional require que todos os separadores presentes estean presentes.
The formula {=CHOOSEROWS(A1:E3;2;3)} returns the array below with rows 2 and 3 chosen.
FFF |
|
|
III |
JJJ |
KKK |
LLL |
MMM |
NNN |
OOO |
The formula =CHOOSEROWS(A1:E3;1;-1) returns the array below with row 1 and row 3 chosen, note that row 3 is chosen from the end of the array.
AAA |
BBB |
CCC |
DDD |
EEE |
KKK |
LLL |
MMM |
NNN |
OOO |
Use the function CHOOSEROWS to reorder the rows of an array. You can also replicate rows by repeating the row index.
COM.MICROSOFT.CHOOSEROWS