Forum Discussion

Karthikumar's avatar
Karthikumar
Copper Contributor
Jul 05, 2020

O365 formulas in standalone excel 2016

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
excel
Formulas and Functions
Macros and VBA
office 365

1 Reply

  • ExcelExciting's avatar
    ExcelExciting
    MVP
    Jul 05, 2020

    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

Resources