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"]