Forum Discussion

AShah16's avatar
AShah16
Copper Contributor
Mar 28, 2022
Solved

Use a Fixed Cell in a Formula which changes based on the row of a column

Dear Experts, I have a situation where i want to use a fixed cell in column A in a formula in Column B. However, i want to change the reference cell in Column A when i reach row 10+1 in Column B. I ...
excel
Formulas and Functions
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Mar 28, 2022

AShah16 That could be:

=A1*OFFSET(A1,-MOD(ROW()-1,10),0)

 

AShah16's avatar
AShah16
Copper Contributor
Mar 28, 2022
Thanks a lot. It worked great.

Resources