Oneide
  • Member for 9 years, 6 months
  • Last seen more than 2 years ago
Is it possible to use named ranges in Google spreadsheet queries so that the columns references are kept up to date?
Accepted answer
5 votes

It's a kind of tricky, but it is possible with a helper Range and some concatenation. What needs to be done: Create a named range, COLS, to carry the column letters like this: A B C D E .....

View answer
How to define the cell to use with a math formula, as a function of current cell?
Accepted answer
1 votes

If i got it right, you may try using the following formula on 'S3': =ROUND(AVERAGE(OFFSET(G$3;3*(R3-2);0;3))) For the cells bellow it, just copy it. Note that I'm using the level collumn (R) as a ...

View answer
Published Google Docs spreadsheet: one data set with 3 sheets each sorted differently
1 votes

Let the raw data be in the first sheet. Then, use the QUERY function to populate the second and the third sheet. Or, if you need more control, create another sheet for the raw data, and use the QUERY ...

View answer
How to drag down 'A1:A2', 'A1:A3', 'A1:A4'
0 votes

Just for the sake of completeness ... Insert in cell B1: =SUM(OFFSET($A$1,0,0,ROW(A1))) Then, just copy or drag it down. Note that the answer by rumtscho is much more efficient, though.

View answer