Forum Discussion
ONLY CERTAIN FUNCTIONS AVAILABLE TO OFFICE USERS
I guess you have perpetual licenses as Office 2019. Microsoft never positioned it as full functional software. It is upgraded from one major release to another, e.g. 2016, when 2019, perhaps next 2022. In between are minor updates. New functionality is added on regular basis only for the subscriptions. How often and which one it depends on subscription. In brief, there is no just Excel, set of functionality provided depends on platform and license purchased.
Bit more about that is here What's the difference between Microsoft 365 and Office 2019?
HiSergeiBaklan , yes I purchased the perpetual Office 2019 thinking that I'd be able to embed a sort command in my formula and save myself multiple steps. I'd imagine that of all the functions that an "Office" would use, sorting would be right up there among the top and therefore included in the offering. Unless, however, it was so obviously important that Microsoft would withhold it to drive their "subscription" offering. Everybody knows that subscriptions are more valuable to a company and command a higher multiple from a valuation perspective, so it makes sense they would try to maximize that part of the business. Would be curious to know how many people would think of sorting as a premium offering.