Forum Discussion

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...

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
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
  Silver Contributor
  Mar 09, 2023
  SergeiBaklan
  I have access to a machine running:
  I can confirm those functions are available.
  - SergeiBaklan
    Diamond Contributor
    Mar 09, 2023
    Patrick2788
    
    Okay, great to know. I based on Release notes for Semi-Annual Enterprise Channel releases - Office release notes | Microsoft Learn