Tag

column names
So, you’re working with Google Sheets and you realize, “Hey, I need to get a specific column. But wait… I need to be able to identify that column by name (i.e. the value of the cell in the first row) because I can’t be sure of the letter that represents each column.” You can do this. Here’s how....
The ability to query Google Sheets as though it were a database is absolutely awesome. There’s just one small challenge: You can’t reference columns by header labels, i.e. the names you add the first row of each column. This limitation exists probably because the first row of a spreadsheet is no different from all the other...