Forum Discussion

davidleal's avatar
davidleal
Iron Contributor
Mar 09, 2023

List of Excel function available for Microsoft 365 Apps for business?

Where I can find such information', is there a link? I noticed for example that people having this version, don't have all the O365 excel functions such as TAKE, I would like to have access to the li...
excel
Excel for web
office 365
Patrick2788's avatar
Patrick2788
Silver Contributor
Mar 09, 2023

I believe a fully updated Semi Annual Channel (if that's your update channel) currently has access to all the functions, IMAGE excepted.

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Mar 09, 2023

Patrick2788 

I'm not sure. 7 lambda helper functions (like MAP) were deployed on semi-annual 2208 in Jan, 2108 still without them. TAKE(), VSTACK() and other are still not on semi-annual.

  • Patrick2788's avatar
    Patrick2788
    Silver Contributor
    Mar 09, 2023

    SergeiBaklan 

    I have access to a machine running:

    I can confirm those functions are available.

      • davidleal's avatar
        davidleal
        Iron Contributor
        Mar 09, 2023

        SergeiBaklan and Patrick2788 for all the information provided. I don't have the mentioned version: Microsoft 365 Apps for business. I was trying to help another person that has this version in another community forum. I use O365, so I don't have a way to test it on my own version whether a  specific excel function is available for another version or not.

         

        so, what is the plan? before responding to someone's question in a forum like this, that has a specific Excel version, make a search in all of the Microsoft channels to see if a specific Excel function was mentioned in the channel then to use it, and if it was not mentioned, don't use it? This is ridiculous. Microsoft needs to do a better job with all this mess having so many versions and similar products, with different excel functions at the same time. Thanks anyway for your time.

         

         

Resources