4 ms·

I only discovered queries in Google Sheets two days ago and it was like magic / “why didn’t I know about this all these years” https://support.google.com/docs/a

I only discovered queries in Google Sheets two days ago and it was like magic / “why didn’t I know about this all these years” https://support.google.com/docs/answer/3093343?hl=en https://support.google.com/docs/answer/3093343?hl=en

cosmie 8y ago
The Sheets Database functions (DGET, DSUM, DAVG, etc) are also really nice, especially after you get familiar with the format for inlining an array of conditions.
tmaly 8y ago
wow, that is useful. this is the first time I have seen this type of query capability in a spreadsheet