TAKE

Formulas / TAKE
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

Examples

  • =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.

Summary

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.


Frequently Asked Questions

What is the TAKE function?
The TAKE function is a Sourcetable tool that returns contiguous rows or columns from an array.
What is the TAKE function syntax?
The syntax for the TAKE function is =TAKE(array, rows,[columns]).
What are the arguments for the TAKE function?
The TAKE function has three arguments:
  • Array (required)
  • Rows (required)
  • Columns (required)
What is the array argument for the TAKE function?
The array argument is the array to take rows from.
What is the rows argument for the TAKE function?
The rows argument is the number of rows to take.
What is the columns argument for the TAKE function?
The columns argument is the number of columns to take.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV