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…