Check Consecutive Increase from first Non-Zero Cell

[haris1]

Hello,

Is there a way to check consecutive growth from first non-zero cell? For example-

[TABLE="width: 646"]
<tbody>[TR]
[TD="class: xl77, width: 70, align: right"] 0[/TD]
[TD="class: xl77, width: 64, align: right"] 0 [/TD]
[TD="class: xl77, width: 64, align: right"]0.15[/TD]
[TD="class: xl77, width: 64, align: right"]0.28[/TD]
[TD="class: xl77, width: 64, align: right"]0[/TD]
[TD="class: xl77, width: 64, align: right"]0.20[/TD]
[TD="class: xl77, width: 64, align: right"]0.41[/TD]
[TD="class: xl77, width: 64, align: right"]1.33[/TD]
[TD="class: xl77, width: 64, align: right"]2.88[/TD]
[TD="class: xl77, width: 64, align: right"]2.04[/TD]
[/TR]
</tbody>[/TABLE]

it should check consecutive growth from col3 till last column.

Thanks for your help.

 

[Eric W]

Given this example, what is the expected result? Does the count reset at 0, or when the value in the next cell is less than the current cell? Would the answer be 4 in this case (F1:I1)?