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

[–] BeardyGrumps 2 points 1 year ago

Many thanks for taking the time to respond and providing the links. To be honest this is the first time I have come across this issue. I knew there were differences between like likes of say excel 2013 vs 2016 vs 2019 but not home business vs office 365. Especially when we checked the excel version numbers and they were the same.

Lesson learnt. :-)