O365 formulas in standalone excel 2016

%3CLINGO-SUB%20id%3D%22lingo-sub-1504658%22%20slang%3D%22en-US%22%3EO365%20formulas%20in%20standalone%20excel%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1504658%22%20slang%3D%22en-US%22%3EI've%20only%20excel%202016%20standalone%20version%2C%20but%20I'd%20like%20to%20use%20some%20formulas%20which%20are%20present%20in%20o365%20eg%3A%20filter()%2C%20join()...%20is%20it%20possible%3F%20alternatively%2C%20is%20it%20possible%20to%20get%20those%20macro%20functions%3F%20so%20that%20it%20can%20be%20used%20in%202016.%20thanks%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1504658%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%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor
I've only excel 2016 standalone version, but I'd like to use some formulas which are present in o365 eg: filter(), join()... is it possible? alternatively, is it possible to get those macro functions? so that it can be used in 2016. thanks
1 Reply
Highlighted

Hi @Karthikumar;

 

There is NO way of using these new function in Excel 2016, yes you can find the UDF function available on internet. But another way of enjoying this new functions by using Excel Online you can find these new function available.

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more