3 ms·
Gsheets offers some formulas I found quite useful and would be a pain to replicate in Excel.
by m-p-3 4y ago
Gsheets offers some formulas I found quite useful and would be a pain to replicate in Excel.
- goatlover 4y agoExcel has lambdas now.
- usr1106 4y agoExcel formulas have a horrible 1970:ish syntax. Reminds me of BASIC programming. But typically I get the job done, sometimes after several awkward intermediate steps. I wasn't aware that Google has a different one. I have never used more than simple sums and differences in Google sheets. Can you give an example where Google offers better, incompatible functionality?
- m-p-3 4y agoFor example, QUERY [1], SPLIT [2] and ARRAYFORMULA [3] are the ones that comes to mind. To be fair MS Excel can do arrayformulas, but I prefer GSheet's syntax. Last time I tried Excel, TRANSPOSE wasn't a thing it but it seems to be there now. [1]: https://support.google.com/docs/answer/3093343 https://support.google.com/docs/answer/3093343 [2]: https://support.google.com/docs/answer/3094136 https://support.google.com/docs/answer/3094136 [3]: https://support.google.com/docs/answer/3093275 https://support.google.com/docs/answer/3093275
- LegitShady 4y agoexcel is fully programmable with vba.