Posts by Skylane60

Re: Hide duplicate running total values.

I agree. Thank you for the help!

Re: Hide duplicate running total values.

File attached

Re: Hide duplicate running total values.

This what I see, when the Error rule is turned: ON.
The blue, green, purple, and turquoise columns each have the formula.

[ATTACH=CONFIG]72463[/ATTACH]

Re: Hide duplicate running total values.

I am not doubting, that you don't see the error on your worksheet.

However, it does present in two different worksheets where I have tested the formula.

With the Error handling rules : "Formulas which omit cells in a region" Unchecked, these errors will not present across the worksheet.

Might be a Excel 2016 bug.

[ATTACH=CONFIG]72462[/ATTACH]

Re: Hide duplicate running total values.

The formula worked fine. Thank you!
However, it does produce the below error for cells that have no values.
I can turn off the Error checking rule to resolve this, but it would be a bonus if the formula checked for the error.
This is not that big of an issue, just a little aesthetically unpleasing.

[ATTACH=CONFIG]72460[/ATTACH]

Re: Hide duplicate running total values.

Thank you AliGW.

This appears to have resolved the issue.
There is a small error issue when the formula omits adjacent cells, but I think I can resolve this easily enough.

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