accumulator with other than one
Hi Gord,
I agree with you entirely. So does John McGimpsey, apparently; this is what he states on his site:
<I dislike accumulators on a spreadsheet, primarily because they retain no history - if an error is made, it may be impossible to
track down in an accumulator, where if the numbers were entered sequentially in a column of cells, they could be examined and
corrected
But the question keeps coming back in the newsgroups!
Since John's warning is included in the link, I just give the link.
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"Gord Dibben" <gorddibbATshawDOTca wrote in message ...
| Dan
|
| As Niek points out...it can be done.
|
| But what happens if you make a mistake in data entry?
|
| You have no "paper trail" to follow to troubleshoot entries.
|
|
| Gord Dibben MS Excel MVP
|
| On Tue, 21 Nov 2006 22:46:02 -0800, Dan wrote:
|
| All -
|
| I am trying to figure out how to do a accumulator to an existing report that
| has numbers in it already and want to update from those numbers...
|
| example [3456] [2123] updater cell [412]
| the two above change as I update the other from this point....
|
| any help is greatly appreicated.....thanks
|
| V/r MSgt ANDERS
| OEF Afghanistan
|
|