Modify formula, col B, to refer to current row when a row is added to the table. The formulas in column B operate correctly until a row is added to the table using [Tab] or typing in the row below the bottom table row. To correct the error, the formula in col B must be copied from a properly-referencing formula two rows above.
Could a function using INDIRECT(row)-1 or similar approach work? Tried deleting the formulas, e.g.,
Col B problem formulas:
) & ".","") <--Note there are double ending brackets
Tried retyping them to have the same function construct as those in
col D which operate correctly after a new row is added:
<--Note there are single ending brackets in the OK Col D formulas.
Thanks in advance