TAKE

TAKE(array, rows [,columns])

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

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

REMARKS
* This function was added in Microsoft 365.
* 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

 ABCDE
1=TAKE(C1:E3,1) = {1,2,3} 123
2=TAKE(C1:E3,-1) = {7,8,9} 456
3=TAKE(C1:E3,,1) = {1,4,7} 789
4=TAKE(C1:E3,,-1) = {3,6,9}    
5=TAKE(C1:E3,1,1) = {1}    
6=TAKE(C1:E3,-1,-1) = {9}    
7=TAKE(C1:E3,2,2) = {1,2 ; 4,5}    
8=TAKE(C1:E3,-2,-2) = {5,6 ; 8,9}    

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

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top