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 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 |
|
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