Forum Discussion
- kuhansCopper Contributor
ZFILL function is not available in excel office 365
- rmianoCopper Contributor
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/
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.
- MuhammadiyyaBrass Contributor
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 pleaseHansVogelaar