3 ms·
You could do that in Excel, but Data Tables are the better way.
by andy81 3y ago
You 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).