Formulas and Functions
TAKE
The TAKE function returns a specific number of rows and columns from an array.
TAKE(array, number-of-rows, number-of-columns)
array: The array from which to take rows or columns.
number-of-rows: The number of rows to take.
number-of-columns: The number of columns to take.
Notes
A negative value for number-of-rows or number-of-columns takes from the end of the array.
You can use the spilled range operator “#” to reference an array created by a formula.
Examples |
|---|
=TAKE(A1:C10, 5, 2) returns the first 5 rows and first 2 columns. =TAKE(A1:C10, -3, -2) returns the last three rows and last 2 columns. =TAKE(A1:C10,,-2) returns the last two columns. |