How to find consecutive patterns within rows based on value requirements
I'm trying to find a way to identify particular patterns within a large sheet, basically identifying specific lack of consistency.
So in the example here (spreadsheet link).. Bill, Jose, Ted, and Pedro are consistent, so far as their rows go. Rich is not consistent, with that jump from 2% to 98% from D4 to E4.
What I'd like to be able to write out to define the consistency is something like "find cells where the previous X cells are <=Y%, then the next cell is >=z%". So for Rich, his E4 cell would qualify if i could say "find cells where the previous 3 cells are <=10%, then the next cell is >=90%."
Thanks so much for any assistance.
