How to check consecutive rows and flag if not blank
I have a sheet where I'm tracking utilization on a weekly basis.
I need to check if utilization gets over a threshold on 3 consecutive rows.
but I'm not sure how to do this.
In the example below Row 7 should have something on the "Alert?" Column, as it passed the threshold 3 times in a row.
Help Article Resources
Check out the Formula Handbook template!