On 15 jun, 00:04, Harlan Grove wrote:
vsoler wrote...

...For example, if A1:A5 contains:

3
8
5
1
6

Then, the formula should return

3
11
16
17
23

...

FTHOI, an approach that uses no volatile functions, and could work as
easily with an array as a range. If your original range were named D,
then the array formula

=MMULT(--(ROW(D)=TRANSPOSE(ROW(D))),D)

returns

{3;11;16;17;23}

Harlan,

I really like your proposed solution, it works really well.
Thank you