ExcelBanter - modifying formula reference

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - modifying formula reference (https://www.excelbanter.com/excel-programming/364021-modifying-formula-reference.html)

referrrrrr

modifying formula reference

Hi, please help with the following:

I have formula that refers to one cell (lets say A5=B3). When i copy formula
from A5 to A6 (down verticaly), A6 refers to B4 (reference shifts down too).

What should I do to make reference to shift horizontaly? (after copying
formula verticaly to A6, reference should shift horizontaly to C3, not
verticaly to B4) Is this possible and how?

Tom Ogilvy

modifying formula reference

=OFFSET($B$3,0,ROW(A1)-1)

--
Regards,
Tom Ogilvy

"referrrrrr" wrote:

Hi, please help with the following:

I have formula that refers to one cell (lets say A5=B3). When i copy formula
from A5 to A6 (down verticaly), A6 refers to B4 (reference shifts down too).

What should I do to make reference to shift horizontaly? (after copying
formula verticaly to A6, reference should shift horizontaly to C3, not
verticaly to B4) Is this possible and how?

All times are GMT +1. The time now is 02:21 PM.