TAKE

The function returns a specified number of contiguous rows or columns from the start or end of an array.

Syntax

=TAKE(array, rows,[columns])

The function has the following arguments:

Argument	Description
array	Refers to the array from which you can 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 row or column is 0.

The function returns an array, the type of each value in the array depends on the parameter.