TAKE
Returns an array consisting of the specified number of items from the beginning of an array.
Syntax
=TAKE(array, count)
Arguments
| Argument | Type | Description |
|---|---|---|
| array | Array | The array of values |
| count | Number | The number of items at the beginning of the array to include |
Examples
=TAKE([1, 2, 3, 4, 5], 3)→[1, 2, 3]
=TAKE(["A", "B", "C"], 1)→["A"]
=TAKE([], 4)→[]
=TAKE(["x", "y", "z"], 4)→["x", "y", "z"]
Updated over 1 year ago