List of Excel functions only in office 365

[Stephen_Safee]

Hello, 

What is the list of all Excel functions ONLY available in office 365 (and so NOT in office 2019) ?

Thank you.

Stephen

[#2 · Accepted solution]

@Stephen_Safee 

See New Functions in Microsoft 365 

[#3]

The linked article posted by @HansVogelaar has some great information, but since it doesn't mention the new 365-only FILTER function (which radically simplifies the complex INDEX + SMALL + ROW array formula to pull nth occurrences), I googled to see whether there were others and found this list of another five described as being "for 2021" (SORT/SORTBY; UNIQUE; XLOOKUP; FILTER; SEQUENCE): https://www.xelplus.com/excel-functions-office-365/

[#4]

@rmiano 

The list in the link in my previous reply has been updated since the release of Office 2021.

Functions such as FILTER are not Microsoft 365-only anymore - they are now available in Office 2021 as well. The link now lists the functions that are available in Microsoft 365 but not in Office 2021.

[#5]

@HansVogelaar 

ZFILL function is not available in excel office 365

[#6]

please how do I handle this error? I've clicked repair now several time each time the error pops up but it'll only exit the Excel app same error pops up in Word too and the app closes as soon as I click repair now.

what could be the cause and the possible solution please@HansVogelaar 

[#7]

@Muhammadiyya 

Your question has nothing to do with this discussion.

Please start a new discussion.