3 ms·
Google Sheets has a "query" function in which you can write out SQL-like scripts and I have found it to be tremendously useful. I've been disappointed that a s
by tryitnow 10y ago
Google Sheets has a "query" function in which you can write out SQL-like scripts and I have found it to be tremendously useful. I've been disappointed that a similarly easy-to-use function doesn't exist in Excel. This is a solution to that problem.
At first I thought this might not be all that useful given Excel's Power Query functionality, but then I realized there are still a lot of use cases where this could come in handy.