Conditional Counting + Comparison

[klosheen]

Hi,

Below is a table with the daily settlment price for ICE Brent Futures. Highlighted in red are three consecutive days on which Brent finished in the red. I would like to be able to find the last time Brent suffered three consecutive daily losses or more. In other words, I would like to be able to make statements similar to the following: "This is Brent's longest losing streak since the [# of days] ended [date]."

Many thanks for all your help in advance.

 

[XOR LX]

When you change array formulas you need to re-commit them as per the original instructions. See the footer in my earlier post if you can't remember how to do it.

Regards

 

[oldbrewer]

your link still does not work it is a list but not a spreadsheet

 

[klosheen]

When you change array formulas you need to re-commit them as per the original instructions. See the footer in my earlier post if you can't remember how to do it.

Regards

It works . Thank you so much for your help.

 

[XOR LX]

You're welcome!