Forum Discussion
Solved
Absolute referencing when adding columns.
Hello experts, I have been looking for an answer to this question for a couple of days now, without any luck. I hope you are able to help me. I'm looking for at way to keep cell references when...
Use
=AVERAGE(OFFSET(X2, 0, -13, 1, 4))
and fill or copy down. This means: take the average of the range starting 13 cells to the left of X2, i.e. in K2, and 4 columns wide.
Use
=AVERAGE(OFFSET(X2, 0, -13, 1, 4))
and fill or copy down. This means: take the average of the range starting 13 cells to the left of X2, i.e. in K2, and 4 columns wide.
HansVogelaar
Thank you so much! It seems to work exactly like i hoped
Thank you so much! It seems to work exactly like i hoped