Countifs between a certain value
HI
I need to count the values between a set value, and then only show how many times this count was more than 5. The values counted is variable only the between value is set
This is in the same column lets say from a1. DD is your set value, in the below example my answer should be 2 ( there are only 2occurrences where there are more than 5 data sets between the DD parameter)
1
5
4
7
DD
7
5
2
9
7
1
5
3
1
1
2
DD
6
8
7
1
DD
7
5
2
9
7
1
5
3
1
1
2
DD
6
8
7
Thank you
Gerhard
|