Hello
I have this row 1:
0,0,0,0,2,0,0,0,0,3,0,0
I want to put a formula in the row below (row 2) that will return the first non zero value searching from right to left in the range from $A$1 to [current column, row1]
Any idea?
Thanks!
I have this row 1:
0,0,0,0,2,0,0,0,0,3,0,0
I want to put a formula in the row below (row 2) that will return the first non zero value searching from right to left in the range from $A$1 to [current column, row1]
Any idea?
Thanks!