3 ms·
In case it's useful to anyone: google sheets' lambda[1] and map[2] functions have prevented a ton of fill-down issues for me. Plus the ability to use a whole co
by artlessmax 3y ago
In case it's useful to anyone: google sheets' lambda[1] and map[2] functions have prevented a ton of fill-down issues for me. Plus the ability to use a whole column without specifying number of rows (e.g. "A1:B" instead of "A1:B1000")
Those functions + a little bit of custom app script have helped me (not very technical) get pretty far in building maintainable data pipelines, reporting, etc. in gsheets.
[1] https://support.google.com/docs/answer/12508718 https://support.google.com/docs/answer/12508718
[2] https://support.google.com/docs/answer/12568985 https://support.google.com/docs/answer/12568985
- WastingMyTime89 3y agoAll of this is available in Excel by the way.
- artlessmax 3y agoOh, I didn't realize they had map now -- thanks!
- nerdponx 3y agoThe "traditional" Excel solution is Array Formulas.
- artlessmax 3y agoBut Index/Match doesn’t play nice with array formulas :/
- andy81 3y agoYou could do that in Excel, but Data Tables are the better way.
- artlessmax 3y agoI think Excel Tables make a ton of sense, especially if you're using PowerQuery or other built-in data connections to populate the sheet. But for Google sheets, I've yet to find something as flexible and maintainable as map/lambda -- especially when I'm doing things that are pretty... egregiously hacky, but better suited to gsheets than excel (I still prefer Google's realtime collaboration to Microsoft's).