Hi everybody!
Need help to do the calcution within the list.
Here is a list with items(#1,#2,#3,...), and properties of Input and Output.
The Output is supposed to be the maximun value of the input from #1 to the current item as below table.
Anyone has solutions about this? I found it difficult to calculate list item dynamically.
Name | Input | Output | ※How to calculate the Output |
#1 | 25 | 25 | =MAX(#1:#1) |
#2 | 20 | 25 | =MAX(#1:#2) |
#3 | 30 | 30 | =MAX(#1:#3) |
#4 | 10 | 30 | =MAX(#1:#4) |
#5 | 40 | 40 | =MAX(#1:#5) |
#6 | 30 | 40 | =MAX(#1:#6) |
#7 | 20 | 40 | =MAX(#1:#7) |
#8 | 25 | 40 | =MAX(#1:#8) |
#9 | 10 | 40 | =MAX(#1:#9) |