Summarizing and filtering data with QUERY and a Google Sheet drop-down
January 31, 2018
I had another opportunity to learn a thing or two about Google Sheets and it’s internal functions. Again. On a similar topic as last time.
This time around I had to summarise the data from 4 different sheets and then let the user filter the data dynamically.
To do this, I had to look up a lot of things, learn a little bit about the QUERY-function and then jump through some hoops. I write this down here so that I don’t have to learn this again. You can read it if you want to.
I’ve created a sheet with some example data, similar but not the same as the data we had. This was also, as last time, a survey about the state of our office that we needed to summarise for a meeting.
We had asked for input and asked people to classify...