Count and sort in Google Sheets using QUERY()

When I’ve pulled some data into Google Sheets I often want a way to quickly chart the count of something, maybe it’s support tickets and I want to chart the incidence of particular tags or count tickets for each customer. In this situation I want a nice neat chart showing from ordered data.

Closing all the Photoshop layer groups at once

The great thing about Twitter is the ability to ask all my talented friends for solutions to immediate problems, in the same way as I might turn around in an office and ask questions of my nearby colleagues. All well and good, but the question and the answer aren’t collated which is mildly frustrating and …