4 ms·
Has google sheets filled out the lambda helper functions yet? If so that could narrow the gap. Passing around vba based xlsm is really awful, so if google shee
by knollimar 11mo ago
Has google sheets filled out the lambda helper functions yet? If so that could narrow the gap.
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?
- hahn-kev 11mo agoNot sure what lambda helpers are. But you can write Google AppScript which is just JS and do some pretty cool stuff, including define custom functions and fully integrate with Google APIs. I've used to to send emails, or create calendar events for example.
- knollimar 11mo agoByrow, bycol, map, reduce, scan, makearray, and most recently groupby and pivotby. Basically functions that take a lambda argument and apply it over some range.