TAKE
Returns a specified number of contiguous rows or columns from the start or end of an array
Syntax
TAKE(array, rows, [columns])
Parameters
- array: Required. The array from which to take rows or columns
- rows: Required. The number of rows to take (negative takes from end)
- columns: Optional. The number of columns to take (negative takes from end)
Example
=TAKE(A1:D10, 3)