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...
=INDIRECT(ADDRESS(117,ROW()-110))-INDIRECT(ADDRESS(113,ROW()-110))You can try this forrmula which is in cell A113 and filled down.