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


Did this page help you?