newbie question, is it possible to select columns by name rather than letter when using Google Query Language with Google Spreadsheets?
This works fine for me: "SELECT A, COUNT(B) GROUP BY A"
It'd be great if I could use the column headers in the first row, more like a database, as in:
"SELECT student, COUNT(detention) GROUP BY student"
I suspect it's not possible, but hope this yet another case where my Internet search skills failed me.