Had to vent somewhere; spent a few week on and off developing a compensation system in Excel and PowerBI for a company with several divisions. Pretty simple stuff; they just wanted to benchmark and log compensations across different geographies.
In order to populate some dropdowns I used the functions SORT, UNIQUE and FILTER for the first time. Was told all clients use Excel 2019 whereas I have a office 365 subscription. Well it turns out these functions are not available in excel 2019 home and business; only in the Office 365 version. (Even though I checked the version numbers of excel and we were all using the same).
What kind of money grabbing scheme is this… Was a simple workaround by creating the same functionality with a few lines of VBA but even so…
It’s as bad as giving Excel 2021 the LAMBDA function in an update, waiting for people to use it, then removing it in another update so that their new workbooks no longer work.
I still have access to LAMBDA in my install of office 2021. I may not have updated. Now I just won’t.