Forum Discussion
I can't find filter function in office 2019
I find it's one thing to never add new functionality to Office 2019 but quite another to disable the functionality it once had in order to force you to the cloud version off Office.
This is one more reason why the government should put some limits on big tech firms - I say that and I'm a big tech supporter and against government controls but big tech continues to abuse their position by disabling my software on my computer that I paid for
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?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...
- That's curious since I used it regularly for years until a few months ago and I've spent 4 months trying to figure out what was wrong so I could keep using it to quickly sort my customer list in Excel...
- There is Filter functionality in older Excel but not the FILTER() cell function.
You (old Excel) can Create Tables or add the Quick Filter drop downs or just go under the Data tab and use the Filter button to filter a set of data.
You (old Excel) can NOT write a cell based formula to dynamically FILTER a set of data and return the results to this new location.
Does that help?
