TAKE function
Returns a specified number of contiguous rows or columns from the start or end of an array
Syntax
TAKE(array, rows, [columns])Square brackets indicate optional arguments.
Arguments
| Argument | Required | Meaning |
|---|---|---|
| array | Yes | The array from which to take rows or columns.A2:C4 |
| rows | Yes | The number of rows to take. A negative value takes from the end of the array.2 |
| columns | No | The number of columns to take. A negative value takes from the end of the array.2 |
Try TAKE
Keep the available array when negative counts exceed both dimensions
=TAKE(A2:C3,-8,-8)The source has two rows and three columns. Negative counts select from the end; requesting eight in both dimensions returns every available source cell, preserving row and column order.
Inspect the current formula
Read its written arguments or observe actual operation values in a separate local calculation. This action neither applies a draft nor grades an answer.
Read the formula, one argument at a time
Explore the written function calls and their inputs. The calculation result belongs to the complete formula.
TAKE · top-level call
=TAKE(A2:C3,-8,-8)Follow the cells behind a result
Read explicit local references and helper formulas using a separate calculation. Your draft stays in this field; the worksheet and practice checks do not change.
The worksheet runs locally. Published checks apply to the supplied example only. Native Excel and Google Sheets compatibility remain unverified.
Practice a complete task
Reference and compatibility
Univer 1.0.4 / Apache-2.0. Calculation checks cover the supplied examples only. The browser worksheet does not implement every Excel feature, external service or connected data type.