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

6 Replies

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

     

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    May 10, 2022

    wmipbw 

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

    =INDEX(data,,n)

     

    • wmipbw's avatar
      wmipbw
      Copper Contributor
      May 10, 2022
      HI,
      Thanks Lot Actually I need Add CHOOSECOLS to my function list, I will find a way to add Beta channel. If you Ok Please guide me for that as well.
      Best regard
      Indika Wickramasinghe

Resources