TAKE
Description
Returns a subset of the specified array, from the start or end of an array, based on the
number of rows or columns that you specify.
Syntax
TAKE(
array
,
rows
,[columns
]) - array: The array to take rows or columns from.
- rows: The number of rows to take. If you specify a negative value, the function takes from the end of the array.
- columns: The number of columns to take. If you specify a negative value, the function takes from the end of the array.