From a list of values find the first sequence of values that are less than x

Hi all,

I'd really appreciate if anyone can give me some help with my latest challange - i'm really struggling!

I'm trying to workout a formula in F5 that will search the list in C6:C33 and find the first sequence of
3 consecutive numbers (defined in F9) that is less than 1% (defined in F8).

I've found a formula online which will allow me to get a sequence of numbers that match exactly but i can't work out how to make it look for values that are less than.

=MATCH(1, COUNTIFS(E3, B1:B23, E4, B2:B24), 0)

Please help! Any help appreciated!

Hi -

Please don't post photos of your spreadsheet. Retyping your data leads to errors and slows us down in getting you quick answers! It would be VERY helpful if you would post a copy of your spreadsheet. Simply click the Go Advanced button, scroll down to the Manage Files button, and then follow the directions to attach and upload your spreadsheet.

Thanks,

Oops! Sorry! I see you did post your spreadsheet. My bad!

Please try

Please Login or Register  to view this content.

Press Ctrl-Shift-Enter for ARRAY formula


Regards.

If you can not use textjoin or don't want to use ARRAY formula,
please use these formulas.

D6 (and copy down untill the end of data)

Please Login or Register  to view this content.

F5

Please Login or Register  to view this content.

Regards.