I have a question re formula.
I have a workbook that contains the % of accuracy for each entity.... I.e. Jan to Dec (75%,92%...).
What I want to do is to count the consecutive occurrences where they have failed to meet a target (i.e. 95%) but if they meet the target its reset to zero until the following month where the consecutive would be 1 if they missed.
In the below example there would only be 3 consecutive occurrences (Sep-Nov.) as Aug was 97% so above target so reset the count back to zero. However if I was calculating for Jan - Jul it would have been 7 until August month.
Hope this makes sense....anyone help?
<tbody>
</tbody><colgroup><col span="11"></colgroup>
I have a workbook that contains the % of accuracy for each entity.... I.e. Jan to Dec (75%,92%...).
What I want to do is to count the consecutive occurrences where they have failed to meet a target (i.e. 95%) but if they meet the target its reset to zero until the following month where the consecutive would be 1 if they missed.
In the below example there would only be 3 consecutive occurrences (Sep-Nov.) as Aug was 97% so above target so reset the count back to zero. However if I was calculating for Jan - Jul it would have been 7 until August month.
Hope this makes sense....anyone help?
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov |
75% | 92% | 92% | 75% | 76% | 85% | 76% | 97% | 89% | 70% | 83% |
<tbody>
</tbody><colgroup><col span="11"></colgroup>