TAKE Function

The TAKE function is one of the lookup and reference functions. It is used to return rows or columns from array start or end.

Syntax

TAKE(array, rows, [columns])

The TAKE function has the following arguments:

Argument	Description
array	Is used to set the array from which to take rows or columns.
rows	Is used to set the number of rows to take. A negative value takes from the end of the array.
columns	Is used to set the number of columns to take. A negative value takes from the end of the array.

Notes

Please note that this is an array formula. To learn more, please read the Insert array formulas article.

How to apply the TAKE function.

Examples

The figure below displays the result returned by the TAKE function.

Alla pagina precedente