Using Google Spreadsheets, you can write queries. However, if you have column letters in quotes, then they aren't updated as column order changes.
Is there a way to write these queries so they don't need to be updated every time a column is added or removed?
Is it possible to use named ranges in queries to solve this problem?
Here's an example: If you add a column after 'F', then column 'G' gets pushed to 'H' and the meaning of the formula changes.
=Query(B:J,"select avg(J) group by G")
This question is not the same as Using Query with column headers instead of column letters because this one is focused on the use of named ranges.