I am wondering how to go about the following problem:
Say I have a column with the following numbers
0
1
8
9
10
7
0
2
5
8
9
10
14
7
8
19
46
What I want is to go through a long list like this and count the number of times exactly 4 consecutive cells have numbers greater than 6. In this case it will be 1 not 3. It will be 1 for when I want 4 consecutive cells greater than 6 and it will be 1 when I want 8 consecutive cells greater than 6. Hope this makes sense. Any help will be greatly appreciated.
Bookmarks