Forum Discussion
I can't find filter function in office 2019
Hi, I can't find filter function in office 2019, I made updates and read about the inside office but it's not available. Please advice? Regards Hisham
The FILTER function has never been available in Excel in Office 2019. It was introduced in the subscription version Microsoft 365, and the first 'permanent license' version in which it is available is Office 2021.
I wonder why Microsoft FILTER function page lists Excel 2019 as one of the versions compatible with FILTER: https://support.microsoft.com/en-us/office/filter-function-f4f7cb66-82eb-4767-8f7c-4877ad80c759
How should I read it, as a mistake from that page? Or are there 2019 versions compatible with FUNCTION?
How should I read it, as a mistake from that page? Or are there 2019 versions compatible with FUNCTION?
It's an error in the documentation. Excel 2019 does NOT have the FILTER function.
So Microsoft was trying to downgrade the 2019 product to force people into the cloud? They were partially successful but I'll be the first to support the US Congress' limiting of Microsoft's power and any anti-trust cases that come up...
More exactly the force people on subscription model, not exactly into the cloud. You may subscribe on 365, download and install apps and never work in the cloud directly.
Do you accept this or not that's another story.
