Jun 05 2020 01:27 AM
Jun 05 2020 01:43 AM
@heshamsheeha MS support pages indicate the following regarding FILTER:
Note: This function is currently available to Microsoft 365 subscribers in the Monthly channel. It will be available to Microsoft 365 subscribers in the Semi-Annual channel starting in July 2020. For more information on how features are rolled out to Microsoft 365 subscribers, see When do I get the newest features in for Microsoft 365.
Jun 06 2020 06:42 AM
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
Jun 06 2020 11:31 AM
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.
Jun 06 2020 11:59 AM
May 27 2022 01:48 PM
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
May 27 2022 02:29 PM
May 27 2022 02:35 PM
Mar 10 2023 08:02 AM
Mar 10 2023 10:19 AM
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...
Mar 11 2023 04:01 AM
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.
Mar 11 2023 11:41 AM
Mar 11 2023 04:07 PM
Mar 13 2023 08:31 AM
I'm on subscription model for a long while and not sure how smooth the transition on it. Only may say I have, among others, IMAP account connected to my 365, it works without any problems.
IMHO, in general it shall be no difference between subscription and one-time purchase models except money you pay and set of features you have.