TAKE Function. Get rows and columns from range of cells.(Microsoft Excel)
The TAKE function is a new function added to Excel in September 2022 that retrieves a portion of a cell range.
This function is often used in combination with other functions.
How it works
=TAKE(array,rows,columns)
Name | Omission | Explanation |
---|---|---|
array | Required argument. Specify the target cell range. | |
rows | Specifies the number of lines to retrieve. To retrieve all rows, specify no number; to retrieve from the tail, specify a negative number. | |
columns | Specifies the number of columns to retrieve. To retrieve all columns, specify no number; to retrieve from the tail, specify a negative number. |
Demonstrate
The first argument is the target cell range, and the second argument is the number of rows to be retrieved.
![](https://www.samurai-emblem.com/wp-content/uploads/2023/01/image-64.png)
If the second argument is negative, it is taken from the tail.
![](https://www.samurai-emblem.com/wp-content/uploads/2023/01/image-65.png)
The third argument is optional.
This argument specifies the number of columns to retrieve.
To retrieve all rows, specify nothing for the second argument, followed by a comma.
![](https://www.samurai-emblem.com/wp-content/uploads/2023/01/image-66.png)
The TAKE function is often combined with the Spill function.
For example, the SORT function is used.
![](https://www.samurai-emblem.com/wp-content/uploads/2023/01/image-67.png)
If the SORT function is specified as the first argument of the TAKE function, only a portion of the results of the SORT function will be retrieved.
This makes it possible to sort the results by price, etc., and obtain only the top 3 results.
![](https://www.samurai-emblem.com/wp-content/uploads/2023/01/image-68.png)
---
Discussion
New Comments
No comments yet. Be the first one!