I am tracking snow data for skiing. In column D I have the snow that fell in the last 24hrs. I want to count how many consecutive times the value over 10 occurs in the column.
I thought I had it with =MAX(FREQUENCY(IF(D2:D153,">10",ROW(D2:D153)),IF(D2:D153,">10",ROW(D2:D153)))))
A B C D E
<tbody>
</tbody>In the above the formula would count D6:D8 giving a value of 3. Thus in column D, 10 14, and 42 are counted because they have a value of 10 and higher consecutively.
Thanks in advance
Byron
I thought I had it with =MAX(FREQUENCY(IF(D2:D153,">10",ROW(D2:D153)),IF(D2:D153,">10",ROW(D2:D153)))))
A B C D E
1 Month | Day | Vis | Snow | Temp |
2November | 22 | 1 | 2 | -2 |
3 February | 20 | 5 | 13 | -10 |
4 February | 21 | 4 | 7 | -11 |
5 February | 22 | 3 | 9 | -12 |
6 February | 23 | 5 | 42 | -11 |
7 February | 24 | 4 | 14 | -11 |
8 February | 25 | 5 | 10 | -14 |
9 February | 26 | 5 | 0 | -16 |
<tbody>
</tbody>
Thanks in advance
Byron