View Single Post
  #5   Report Post  
Max
 
Posts: n/a
Default

"Frank Kabel" wrote
....
this is not really possible with formulas.


Thought the example suggested earlier using a formula in *B40* itself
(with the iteration settings) seems to work ok under light testing ..
of course, within bounds of the caveats mentioned in JE's:
http://www.mcgimpsey.com/excel/accumulator.html
Worksheet Function Accumulator (using Circular References)

--
Rgds
Max
xl 97
--
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
---