count group of Consecutive cells according to cretiria

Hi,

Pls refer to the attached WB for a complete and detailed question.

Thanks, Elm

Try:

Please Login or Register  to view this content.

confirmed with CTRL+SHIFT+ENTER

Here's one way:

With
B1:B100 contains numbers, blanks allowed
E4: (min group size....eg 3)
E5: (Floor amount.....eg 10)

This ARRAY FORMULA, committed with CTRL+SHIFT+ENTER
(instead of just ENTER), returns the count of groups of
consecutive values in col_B where:
• the amount is greater than E5
• the group count is equal to or greater than E4

Please Login or Register  to view this content.

Is that something you can work with?

Thanks, NBVC,

It looks fine and close but to my opinion, not good enough.

Try to reduce the value of B13 or B14 or B15, to 9.9 which should change the result to 2 but, unfortunately, it remains 3.

================================
Thanks, Ron,

Your formula looks much more promising.

I will check it out this afternoon on several combinations.

Elm

Sorry... slight formula adjustment..

Please Login or Register  to view this content.

confirmed with CSE keys

Edit: Just noticed Ron's solution... similar to my adjusted formula... the only difference is whether you want > or >= E5 and/or E4 in the formulas...

zebinza, welcome to the forum,

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.