Forum Discussion
I can't find filter function in office 2019
Helloheshamsheeha
The FILTER Function is one of the Six Dynamic Array functions functions and they are currently available to subscribers on the Insiders Fast and Microsoft 365 Monthly Channel E3/E5
Semi-Annual and Annual Channels to follow suit
Maybe Microsoft will include it in Office 2022
- heshamsheehaJun 06, 2020Copper Contributor
Dear the whole filter function is not appearing in the excel 2019Abiola1
is it available without subscribe
?
Thanks
Hisham
- heshamsheehaJun 06, 2020Copper Contributor
how to subscribe to Insiders Fast and Microsoft 365 Monthly Channel E3/E5 and i install already office 2019 Abiola1
- SergeiBaklanJun 06, 2020MVP
The difference between 2019 and 365 is here What's the difference between Microsoft 365 and Office 2019? In particular, it says 2019 never will have new functionality.
How to upgrade it's better to ask your local reseller, afraid you shall just to purchase the subscription. Bit more is here How do I upgrade Office?
Which version it's depends on how are you going to use Office. From dynamic array functionality point of view it's not necessary enterprise E3/E5, that could be Family or others, it's important to updater from semi-annual on current or beta channels. However, dynamic arrays will be on semi-annual as well in couple of months or so. Functionality for concrete subscription it's better to check additionally.
- Andresen375May 27, 2022Copper Contributor
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
- Abiola1Jun 06, 2020MVPHello,
You can read up how to upgrade from the article in the link below
https://support.office.com/en-us/article/how-do-i-upgrade-office-ee68f6cf-422f-464a-82ec-385f65391350