CHOOSECOLS(array, col_num1 [,col_num2] [..])

Returns the specified columns from an array.

arrayThe array(s) to append.
col_num1The column number to be returned.
col_num2(Optional) The column number to be returned.

* Added in Microsoft 365 and is only available to Office Insiders at the moment.
* You can use the CHOOSEROWS function to
* This function was released in March 2022.
* For the Microsoft documentation refer to


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