TAKE function
Summary
Returns a specified number of contiguous rows or columns from the start or end of an array
Syntax
TAKE(array, rows,[columns])
The TAKE function syntax has the following arguments:
• array The array from which to take rows or columns.
• rows The number of rows to take. A negative value takes from the end of the array.
• columns The number of columns to take. A negative value takes from the end of the array.
• array The array from which to take rows or columns.
• rows The number of rows to take. A negative value takes from the end of the array.
• columns The number of columns to take. A negative value takes from the end of the array.
Example
=TAKE(A2:C4,2)