Forum Discussion
Copying formulas with gaps in reference cells?
Sorry if this question has already been asked before, I'm not very good at Excel so I'm honestly not even sure how to describe my question 😞 Basically, I have some samples that I've taken multiple...
=SQRT(INDIRECT(ADDRESS(2+(ROW(A1)-ROW($A$1))*3,COLUMN(C1)))*INDIRECT(ADDRESS(3+(ROW(A1)-ROW($A$1))*3,COLUMN(C1))))/INDIRECT(ADDRESS(4+(ROW(A1)-ROW($A$1))*3,COLUMN(C1)))
This formula returns the intended result in my sheet. The formula in cell L2 is copied across range L2:N5.
OliverScheurich Thank you so much, that works!! Just so I can actually understand how it works, could I ask what the 2+, 3+, or 4+ are for? How would I need to change them in different scenarios? nevermind, played around with it for another minute and figured it out lol, thanks so much again for your help!!