The function returns a specified number of contiguous rows or columns from the start or end of an array.
=TAKE(array, rows,[columns])
The function has the following arguments:
|
Argument |
Description |
|---|---|
|
array |
Refers to the array from which to take rows or columns. |
|
rows |
Refers to the number of rows to take, A negative value takes from the end of the array. |
|
columns |
[Optional] Refers to the number of columns to take. A negative value takes from the end of the array. |
The function returns a #CALC! error to indicate an empty array when either of the row or column is 0.
The function returns an array, the type of each value in the array depends on the parameter.
This function is available in product version 16.0 or later.