Thursday, September 04, 2008 – Permalink –
Running Total in Comment
You can't have a worksheet formula that looks like this:
But you can do something similar if you use VBA and store the results in another location.
"In Microsoft Excel you can avoid circular references when you create a running total by storing the result in a non-calculating part of a worksheet. This article contains a sample Microsoft Visual Basic for Applications procedure that does this by storing a running total in a cell comment."
<Doug Klippert@ 12:06 PM
Comments: Post a Comment