Excel: Conditional Counting + Comparison

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. [IMG]http://i.imgur.com/EpuD4jI.jpg[/IMG]

This question generated 22 answers. To proceed to the answers, click here.

This thread is current as of August 17, 2014.

For more resources for Microsoft Excel