This content has been marked as final. Show 2 replies
TIME FILENAME VALUE1 VALUE2
Hello, is there any function that can help solving following issue?
I have a range of values which i want to compare by time,
I need the following logic: If row value equals to zero, then take previous value which is not equal to zero.
I've tried previous function, but I made mistake in the formula, as I am not familiar with creating counters. And looks like some kind of counters should be created there to pick the right value avove.
=IF(VALUE1=0,previous(VALUE1),VALUE1 as VALUE1_COUNTED,
Would be very thankful for any hints.