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.