CHOOSECOLS |
CHOOSECOLS(array, col_num1 [,col_num2] [..]) |
Returns the array with just a specific number of columns. |
array | The array(s) to append. |
col_num1 | The column number to be returned. |
col_num2 | (Optional) The column number to be returned. |
REMARKS |
* This function was added in Microsoft 365. * This function can create a Dynamic Array Formula. * If "col_num" > 0 then columns are counted from the left. * If "col_num" < 0 then columns are counted from the right. * If "col_num" > the number of rows in the array, then #VALUE! is returned. * If "col_num" = 0, then #VALUE! is returned. * 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. * You can use the TAKE function to return the intersection of specific rows and columns in an array. * This function was first released in March 2022. * For the Microsoft documentation refer to support.microsoft.com |
|
1 - What is the first column from the cell range "C1:E3". 2 - What is the last column from the cell range "C1:E3". A negative number is used to count from the right. 3 - What is the second column from the cell range "C1:E3". 4 - What is the second to last column from the cell range "C1:E3". A negative number is used to count from the right. 5 - What is the third column from the cell range "C1:E3". 6 - What are the first and third columns from the cell range "C1:E3". 7 - What is the fourth column from the cell range "C1:E3". There are not four columns. 8 - What happens when one of the column numbers is zero. |
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top