ARRAY.TAKE function

This article describes the formula syntax of the ARRAY.TAKE function.

Description

Take items from front (n > 0) or back (n < 0) of array.

Syntax

ARRAY.TAKE(array, n)

array	is an array or handle to an array.
n	is then number of items to take.

Take items from front (n > 0) or back (n < 0) of array If array has more than one row then take n rows.