View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default 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
|