I have a list of numbers entered manually

1
100
100
10
1
1000
10
1000
1
1000
100
10

I'd like to get the running max - the max value for each sub-array of the initial numbers array. By sub-array I mean numbers from [A1] to [A2], from [A1] to [A3], from [A1] to [A4], etc. The result would be as follows:

1
100
100
100
100
1000
1000
1000
1000
1000
1000
1000

More entries may be added to the initial list of numbers.

CodePudding user response：

custom formula sample:

=INDEX(IF(A3:A="","",
  runningTotal(A3:A,4)))