SORT() and FILTER() functions missing

Which update channel are you on?

You must be using Office 365 subscription. If you are on Semi-Annual channel, make sure that you have July 2020 update.

From MS article.

Note: This function is currently available to Microsoft 365 subscribers in Current Channel. It will be available to Microsoft 365 subscribers in Semi-Annual Enterprise 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.

Edit: I can confirm it's available to Office 365, Version 2008 for Current channel.

Cross-posted: https://www.mrexcel.com/board/thread...ssing.1143755/

365 is a subscription version - it includes a desktop version of Office which gets updates to its functionality - when exactly that happens is determined by which release channel you are set up for. That allows IT departments to test updates etc before they are released to you, rather than being blindsided by an update that may have bugs. You can also sign up to the Insider program to get early release to new features, which is basically beta testing.

1) Yes. You can install desktop application on up to 5 devices with single license.

2) While this is possible, I wouldn't recommend it. Unless you are a developer and need to test different versions. Even then, I'd recommend use of virtual machine, rather than installing 2 different versions of Office side by side.

3) It's based on subscription model. Which allows MS to have steady revenue to keep updating software, without need for customer to purchase separate licenses for each major version.
Office 365, have moved from Office 2013, 2016 to 2019.

This works well for enterprise, business customers. Though some prefer one time purchase over subscription model, and MS kept that as option.

Who knows? It's pretty clear that MS favours a subscription model but I suspect there are still some enterprises that prefer a static version (other than patches) and, as long as that is the case, I'd imagine there will still be such versions.

... (i.e. Office 2021 or something like that)

Not quite. Current Office 365 is equivalent of Office 2019, with additional tools and functions. While MS is strongly pushing toward subscription model, I'd wager they will keep standalone license for while yet.

They won't be added to 2019. At best, you'd have to get the next static version, assuming there is one.

And if MS hold to their usual schedule... it will likely be Office 2022 release likely in late 2021.

Since they've been keeping 3 year cadence, since Office 2007.

Originally Posted by Ricko_uk

Thank you. What cross posting? I posted only once in this forum. The only other post I made, as per your link (!), is in MrExcel.com not on this forum... What has another forum got to do with this?

Perhaps you missed our (and MrE's) rules regarding cross-posting?

As a reminder...

1. Title must briefly summarize your request. (A, Z)

2. Programming code must be enclosed in code tags to improve readability. (A, Z)

Please Login or Register  to view this content.

(or use the # button)

3. Questions that are cross-posted to other web forums must contain links to those posts on those forums or a comment to tell us where else the question has been asked. (A, Z*)

This has nothing to do with posting duplicate threads here, but more to do with not wasting members time where your question could have been answered on another site - it is just plain common courtesy to not waste the time of those trying to help you.