# TAKE

## Content

The function returns a specified number of contiguous rows or columns from the start or end of an array.

>type=note
> **Note**: TAKE is a dynamic array formula, and you need to enable the dynamic array feature in the Workbook.

## Syntax

`TAKE(array, rows, [columns])`

## Arguments

The function has the following arguments:

| Argument | Description |
| -------- | ----------- |
| *array* | [Required] Refers to the array from which you can take rows or columns. |
| *rows* | [Required] Refers to the number of rows to take. A negative value takes from the end of the array. |
| *columns* | [Optional] Refers to the number of columns to take. A negative value takes from the end of the array. |

## Remarks

The function returns a #CALC! error to indicate an empty array when either row or column is 0.

## Examples

![take-snapshot.png](https://cdn.mescius.io/document-site-files/images/8d606653-16a0-474d-b9dc-e2b4d01c2446/take-snapshot.635972.png)