Hi Guys,

maybe you can help me with this one:

We make measurements with numbers 1 to 4000. If there is an error in the measurement, I get the output of the measurement-number.

I need Excel to check if these numbers match certain specifications:
Within these measurements we cannot have more errors than
- 7 in a row
- 12 within any given 100 consecutive measurements
- 5% of the whole set

I can't find a way to get Excel to check for the first two rules. Any suggestions?


Thanks in advance!