Forum Discussion
Formulas automatic fill
In an Excel spreadsheet, I have in one cell the following formula, = C$117 - C$113; in the row below, the formula is, = D$117 - D$113. I want the letters in the formula to be updated as I drag the ce...
As variant, if first formula is in A113, that could be like
=INDEX($C:$Z,17, ROW()-ROW($A$112)) - INDEX($C:$Z,13, ROW()-ROW($A$112))
Many thanks! I will try that.