Retrieve a subset of an array.

`TAKE(array, rows, columns)`

- array - required; the array to extract a specified number of rows and columns
- rows - required; the number of rows to extract, with negative values indicating that the extraction should start from the end of the array
- columns - required; the number of columns to extract, with negative values indicating that the extraction should start from the end of the array

`=TAKE(B3:D11,3)`

The TAKE function can be used to return the first set of columns or rows from a range. For example, this will return the first 3 columns of the range B3:D11.

`=TAKE(B3:D11,4,2)`

The TAKE function can also be used to return a specific set of columns or rows from a range. For example, this will return the first 2 columns of the first 4 rows of the range B3:D11.

`=TAKE(B3:D11,-3)`

The TAKE function can also be used to return the last set of columns or rows from a range. For example, this will return the last 3 cells in the range B3:D11.

`=TAKE(B3:D11,-4,-2)`

The TAKE function can also be used to return a specific set of columns or rows from the end of a range. For example, this will return the last 2 columns of the last 2 rows of the range B3:D11.

The TAKE function is used to select a specified number of rows or columns from the start or end of an array. It requires the array to take rows or columns from, the number of rows and columns to take as its arguments.

- The TAKE function returns a subset of an array based on a condition, determined by the row and column arguments.
- Positive numbers for rows and columns return values from the start of the array, while TAKE returns all rows or columns if the value for a given row or column is positive.

The TAKE function is a Sourcetable tool that returns contiguous rows or columns from an array.

The syntax for the TAKE function is =TAKE(array, rows,[columns]).

The TAKE function has three arguments:

- Array (required)
- Rows (required)
- Columns (required)

The array argument is the array to take rows from.

The rows argument is the number of rows to take.

The columns argument is the number of columns to take.

Drop CSV