TAKE
Returns a specified number of contiguous rows or columns from the start or end of an array.
Lookup & ReferenceDynamic Arrays & LAMBDALookup & Matching EssentialsModern Excel Functions
What it does
Returns rows/cols from start or end of an array.
Syntax
TAKE(array, rows, [columns])
Arguments
array(array) — Source.rows(number) — Rows to take (neg for end).columns(number) — Cols to take.
Examples
Take Top 2
Get first 2 rows.
FORMULA
=TAKE(A1:B5, 2)
RESULT
[1, A; 2, B]
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | ID | Val |
| 2 | 1 | A |
| 3 | 2 | B |
| 4 | 3 | C |