Consecutive Count

[Lonathem]

Hi,

Its my first time to post a query here. Hope you can help me on this one. I have another question related to consecutive count. For example, I have a list of data:

75.2
78.9
75.4
60.2
77.1
99.0
110.
125.

From this I need to know the formula on determining what is the maximum number of times in the array in which data of greater than 75 is consecutively reached. The answer for this example is 4.


Thanks!

[arthurbr]

Shoudn't it be 3?

[DonkeyOte]

Assuming your values are in A1:A8 then

Please Login or Register  to view this content.

[Lonathem]

Many thanks for this. Indeed, very useful

[Lonathem]

Just a quick question, how about I needed to have greater than and EQUAL to 75.

[DonkeyOte]

you would change > to >= and <= to <

[Lonathem]

Again many thanks for this. Really appreciate your quick reply. I'm so glad that I have found this kind of forum. Undeniably, very effective!