Concatenating formulas
When I insert a new row at the top of my spreadsheet, the existing cells move down one row. I then enter the appropriate data in the new row's cells.
The INDIRECT function ensures that the formulas always refer to the cell in the top row of my spreadsheet.
|