Excel

179 readers

1 users here now

A community dedicated to any discussion about Excel. QnA, Discussion of other spreadsheet applications and ancillary programming/scripting are also welcome.

founded 1 year ago

MODERATORS

Baffling7900

Functions behind paywall (self.excel)

submitted 1 year ago by BeardyGrumps to c/excel

5 comments fedilink hide all child comments

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.....

you are viewing a single comment's thread
view the rest of the comments

[–] Baffling7900 1 points 1 year ago

I still have access to LAMBDA in my install of office 2021. I may not have updated. Now I just won't.