Dear all,
I hope you can help me out with a problem I can't figure out myself.
The problem is that I have a data sheat, in which I need to measure the longest uninterrupted number of intervals that the variable is below a certain number. Lets say 37. And the zero's are not included. In the following row the variable is 7 times below 37, and the maximum length of longest uninterrupted number of intervals is 4.
So basically I am looking for a formula that gives me the number 4.
I hope somebody is able to help me out
<tbody>
</tbody>
I hope you can help me out with a problem I can't figure out myself.
The problem is that I have a data sheat, in which I need to measure the longest uninterrupted number of intervals that the variable is below a certain number. Lets say 37. And the zero's are not included. In the following row the variable is 7 times below 37, and the maximum length of longest uninterrupted number of intervals is 4.
So basically I am looking for a formula that gives me the number 4.
I hope somebody is able to help me out
0 |
28 |
26 |
0 |
23 |
26 |
27 |
29 |
38 |
40 |
33 |
0 |
<tbody>
</tbody>