Forum Discussion

wmipbw's avatar
wmipbw
Copper Contributor
May 10, 2022
Solved

CHOOSECOLS function Not available in my EXCEL 365

HI all, I need to use CHOOSECOLS for some task, But it not showing my Excel 365. Need your support to how I can add  CHOOSECOLS function to my function list 
excel
Formulas and Functions
office 365
  • SergeiBaklan's avatar
    SergeiBaklan
    May 10, 2022

    wmipbw 

    That's to update on Beta channel (Office Insider) or use

    =INDEX(data,,n)

     

gopala1976's avatar
gopala1976
Copper Contributor
Sep 17, 2025

HI team, I have an active ms365 subscription and today in my excel files, the functions like CHOOSECOLS are missing . i contacted ms support and they redirected me to here. 

can someone help?

 

Resources