4 ms·
And note that Google Sheets actually has a query() function that allows you to run SQL like queries on your datasets. Few people seem to know this, but for me i
by hencq 13y ago
And note that Google Sheets actually has a query() function that allows you to run SQL like queries on your datasets. Few people seem to know this, but for me it's one of the features where I prefer it to Excel.
- yahelc 13y agoI didn't, that's really useful! Sharing the documentation links for the benefit of others, since it's not easily found: Documentation for the query() function: https://support.google.com/drive/answer/3093343 https://support.google.com/drive/answer/3093343 Query Language Reference: https://developers.google.com/chart/interactive/docs/querylanguage https://developers.google.com/chart/interactive/docs/queryla...
- arethuza 13y agoYou can run queries over data in Excel from inside Excel - using the Get External Data option then selecting the spreadsheet you are working on as the source. However, while investigating this I found that Excel gets quite upset if you import the data from your query into the same location as the source...... :-)