These docs are for v1.0. Click to read the latest docs for v1.2.

TAKE

Returns an array consisting of the specified number of items from the beginning of an array.

Syntax

=TAKE(array, count)

Arguments

ArgumentTypeDescription
arrayArrayThe array of values
countNumberThe 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"]