Returns a specified number of contiguous rows or columns from the start or end of an array.
構文
TAKE(array, rows, [columns])引数
array必須
The array from which to return rows or columns.
rows必須
The number of rows to return; use a negative number to return rows from the end.
columns省略可能
The number of columns to return; use a negative number to return columns from the end.
The TAKE function extracts a subset of data from an array based on the number of rows or columns specified. You can use positive integers to take from the start of the array or negative integers to take from the end.
=TAKE(A1:C10, 3)→First 3 rows of A1:C10Returns the first 3 rows of the specified range.
=TAKE(A1:C10, , -2)→Last 2 columns of A1:C10Returns the last 2 columns of the specified range by leaving the rows argument empty.
Select the target cell
Click on the cell where you want the result to appear.
Enter the formula
Type =TAKE( and select your array, then specify the number of rows or columns.
Press Enter
Close the parenthesis and press Enter to spill the results.
The function will return the entire array without error.
Yes, it is often used with SORT or FILTER to manipulate dynamic arrays.