• The forum (and all other resources in Chandoo.org) will be under maintenance and will be unavailable for a maximum of two hours on the first week of October 2023. The exact date, time and duration of the maintenance are subject to change. We regret the inconvience it may cause.
  • Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Need help for CHOOSECOLS formula in Excel


Excel Ninja

Hope everyone is doing fine. I need help for CHOOSECOLS formula.
I have received one file, this file has 'CHOOSECOLS' formula in it.
However, when I open the file, the formula is reflecting as =_xlfn.CHOOSECOLS(_xlfn._xlws.FILTER(FX!$A$2:$T$50,FX!$N$2:$N$50<0,""),1,4,5,8,10,11,12,14,16), that too in Array.

User has Microsoft Office 365 App for enterprises installed, where as I have Microsoft Excel for Office 365.
User is able to see formula in proper syntax and able to type =CHOOSECOLS too.
When I try to type =Cho, I can only see, = CHOSE in my Excel, I can not see =CHOOSECOLS in my Excel.
How do I resolve this, can anyone please help me in this.
The function was introduced with Windows: 2208 (Build 15601). Do you have that Office version or higher installed? In XL File - Account - About Excel will show you the version