Google Sheets Query Function (2016)

That's a great tool. The other day I had a CSV of ML predicted data which I had to analyse. Created a google sheet with the CSV and wrote Query function to generate reports.

I use query a lot in sheets.<p>The behavior gets wonky when other users apply filters and sorts.

Why MS hasn&#x27;t implemented a similar UDF in Excel is truly beyond me. No, Power BI isn&#x27;t the same thing.

I love Google Sheets. The API is perfect for rapid prototypes and shits