I am trying to count the consecutive weeks an item is below its average for a given period of time. Not sure how to do this. Item 123 should have an output of 3 and item 1234 should have an output of 1.
<tbody>
</tbody>
Item | 10/20 | 10/27 | 11/3 | 11/10 | Avg | Consecutive WK Below Avg |
123 | 15 | 8 | 7 | 6 | 9 | ??? |
1234 | 15 | 14 | 15 | 8 | 13 | ??? |
<tbody>
</tbody>