SOLVED

CHOOSECOLS function Not available in my EXCEL 365

%3CLINGO-SUB%20id%3D%22lingo-sub-3352448%22%20slang%3D%22en-US%22%3ECHOOSECOLS%20function%20Not%20available%20in%20my%20EXCEL%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3352448%22%20slang%3D%22en-US%22%3E%3CP%3EHI%20all%2C%3C%2FP%3E%3CP%3EI%20need%20to%20use%26nbsp%3BCHOOSECOLS%20for%20some%20task%2C%20But%20it%20not%20showing%20my%20Excel%20365.%3C%2FP%3E%3CP%3ENeed%20your%20support%20to%20how%20I%20can%20add%26nbsp%3B%26nbsp%3BCHOOSECOLS%20function%20to%20my%20function%20list%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3352448%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3352532%22%20slang%3D%22en-US%22%3ERe%3A%20CHOOSECOLS%20function%20Not%20available%20in%20my%20EXCEL%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3352532%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1386165%22%20target%3D%22_blank%22%3E%40wmipbw%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat's%20to%20update%20on%20Beta%20channel%20(Office%20Insider)%20or%20use%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel-formula%22%3E%3CCODE%3E%3DINDEX(data%2C%2Cn)%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3352749%22%20slang%3D%22en-US%22%3ERe%3A%20CHOOSECOLS%20function%20Not%20available%20in%20my%20EXCEL%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3352749%22%20slang%3D%22en-US%22%3EHI%2C%3CBR%20%2F%3EThanks%20Lot%20Actually%20I%20need%20Add%20CHOOSECOLS%20to%20my%20function%20list%2C%20I%20will%20find%20a%20way%20to%20add%20Beta%20channel.%20If%20you%20Ok%20Please%20guide%20me%20for%20that%20as%20well.%3CBR%20%2F%3EBest%20regard%3CBR%20%2F%3EIndika%20Wickramasinghe%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3353232%22%20slang%3D%22en-US%22%3ERe%3A%20CHOOSECOLS%20function%20Not%20available%20in%20my%20EXCEL%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3353232%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1386165%22%20target%3D%22_blank%22%3E%40wmipbw%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20depends%20on%20platform%20and%20subscription%2C%20business%20or%20consumer%20one.%20All%20instructions%20are%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Finsider.office.com%2Fen-gb%2Fjoin%2Fwindows%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EJoin%20the%20Office%20Insider%20Program%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3354660%22%20slang%3D%22en-US%22%3ERe%3A%20CHOOSECOLS%20function%20Not%20available%20in%20my%20EXCEL%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3354660%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20lot%20for%20all%20support%2C%20Now%26nbsp%3BCHOOSECOLS%20appear%20in%20my%20function%20list.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20lot%20again%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3361000%22%20slang%3D%22en-US%22%3ERe%3A%20CHOOSECOLS%20function%20Not%20available%20in%20my%20EXCEL%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3361000%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1386165%22%20target%3D%22_blank%22%3E%40wmipbw%3C%2FA%3E%26nbsp%3B%2C%20you%20are%20welcome%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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 

5 Replies
best response confirmed by wmipbw (New Contributor)
Solution

@wmipbw 

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

=INDEX(data,,n)

 

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

@wmipbw 

It depends on platform and subscription, business or consumer one. All instructions are here Join the Office Insider Program

@Sergei Baklan 

Thanks lot for all support, Now CHOOSECOLS appear in my function list.

 

Thanks lot again

@wmipbw , you are welcome