TAKE

TAKE(array, rows [,columns])

Returns the intersection of specific rows and columns in an array.

array	The array from which to take rows or columns.
rows	The number of rows to take.
columns	(Optional) The number of columns to take.

REMARKS

* This function was added in Excel 2024.
* This function can create a Dynamic Array Formula.
* If "rows" < 0, then the values are taken from the end of the array.
* If "columns" < 0, then the values are taken from the end of the array.
* You can use the CHOOSECOLS function to return the array with just a specific number of columns.
* You can use the CHOOSEROWS function to return the array with just a specific number of rows.
* You can use the DROP function to return the array without certain rows or columns.
* You can use the EXPAND function to return the array expanded or padded to specific dimensions.
* This function was first released in March 2022.
* For the Microsoft documentation refer to support.microsoft.com

	A	B	C	D
1	=TAKE(B1:D3,1) = {1,2,3}	1	2	3
2	=TAKE(B1:D3,-1) = {7,8,9}	4	5	6
3	=TAKE(B1:D3,,1) = {1,4,7}	7	8	9
4	=TAKE(B1:D3,,-1) = {3,6,9}
5	=TAKE(B1:D3,1,1) = {1}
6	=TAKE(B1:D3,-1,-1) = {9}
7	=TAKE(B1:D3,2,2) = {1,2 ; 4,5}
8	=TAKE(B1:D3,-2,-2) = {5,6 ; 8,9}

1 - What is the first row from the cell range "B1:D3".
2 - What is the last row from the cell range "B1:D3".
3 - What is the first column from the cell range "B1:D3".
4 - What is the last column from the cell range "B1:D3".
5 - What is the first row and the first column from the cell range "B1:D3".
6 - What is the last row and the last column from the cell range "B1:D3".
7 - What are the first 2 rows and the first 2 columns.
8 - What are the last 2 rows and the last 2 columns.