Its all about Excel. It really is the best spreadsheet, and everyone knows how to use it. But that comes in an Office bundle that includes Teams. And that is why we must suffer.
Passing around vba based xlsm is really awful, so if google sheets has lambdas they can probably get a lead with google sheets queey language over filter.
Groupby and pivotby are the new excel alternative, but if they filled out lambdas, then does that keave VBA and power query as the only reasons for Excel?
Basically functions that take a lambda argument and apply it over some range.
The one failure mode is so fucking insidious where it zeros out your last 2 digits, but otherwise it looks like it pasted OK!