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!
You write "every 10 rows", but from row 10 to row 19 is only 9 rows...
thank you so much for your reply
10
11
12
13
14
15
16
17
18
19
I count 10 rows, but you have been very helpful in making my spreadsheet format looking better. this one question is harder in my opinion may not be possible to automatically update Column H formula with a new $I$row (+10).
10
11
12
13
14
15
16
17
18
19
I count 10 rows, but you have been very helpful in making my spreadsheet format looking better. this one question is harder in my opinion may not be possible to automatically update Column H formula with a new $I$row (+10).
It would also mean that the conditional formula I gave you earlier is incorrect...
- Again, thank you so much for assisting me on this very difficult Column H update. In my inquiry, the Column I row was 1 row prior to the Column H row. Notice row 10 stated $I$row9.
I did not receive your suggestion on how a Conditional formula may solve this.
Example: Column H
Row10 = Column D - $I$row9
Row 11 = Column D - $I$row9
..........
Row 19 =Column D - $I$row18
Yes, 10 ... 19 is 10 rows in total, but if you want the formula to change in row 10, row 19, row 28, row 37 etc., that is every 9 rows, not every 10 rows.