Forum Discussion
Solved
Find last value in a row (that will change) and calculate weighted average
I have an extremely large data set so I think that using the offset function will be too time-consuming. The columns are dates and will have new values added each month. The rows will change positi...
OFFSET(StartingReference,0,ColumnsToDisplace,Height,Width)
If you are on column G, means that you will need to displace only 1 column from your StartingReference and then 12 columns of width (12 months range).
(Column(G)-6)*12-11=1 = ($N$2:Width)$N$2:$Y$2
(Column(H)-6)*12-11=2 = ($Z$2:Width)
$Z$2:$AK$2
And so on...
Thanks Juliano. I think you might be on the right track with this.
Could you please explain to me how this part of the formula works? (COLUMN()-6)*12-11,1,12)
Could you please explain to me how this part of the formula works? (COLUMN()-6)*12-11,1,12)
OFFSET(StartingReference,0,ColumnsToDisplace,Height,Width)
If you are on column G, means that you will need to displace only 1 column from your StartingReference and then 12 columns of width (12 months range).
(Column(G)-6)*12-11=1 = ($N$2:Width)
$N$2:$Y$2
(Column(H)-6)*12-11=2 = ($Z$2:Width)
$Z$2:$AK$2
And so on...
- thank you!