Forum Discussion
Solved
is is possible to update a cell formula in a column
I have a 7000 row spreadsheet that I have to manually update every 10 rows. It is a simple update in column H that requires a new value from column I every 10 rows. Example: Column H Row10 ...
- Thank you so much> I will try this and you get a great night of rest!
It's past midnight where I live, I'm off to bed now.
The formula in H12 could be
=D12-INDEX(I:I,10*QUOTIENT(ROW(H12)-2,10)+1)
This can be filled down.
For H1:H11 it'll return different results than your formula.
Thank you so much> I will try this and you get a great night of rest!