Issue: Have To columns A B: A is my entry column. A row in column A may, or may not have a value imputed. Column B is used for running total. (see example)
[ATTACH=CONFIG]72452[/ATTACH]
I am using the following formula to generate the running total: = IF(ISBLANK(A2),(A2+B1+A2),B1+A2) and have copied it down column B.
The issue that I would like to resolve is to Hide the duplicate running values, when a Cell value in column A is not entered (Blank).
Without interrupting the running total calculation down the column.
I would like to not have to use conditional formatting; which seems to somewhat work.
I would like the outcome to present like this:
[ATTACH=CONFIG]72453[/ATTACH]
Using Excel 2016