Excel Problem on Multiple Consecutive Negative Numbers - Challenging :(

Hi all,

I have been stuck on a problem for quite some time and I was hoping someone can lend me a hand.

Table.PNG

Basically, given a horizontal list of years and values, it would be helpful to have formulas that return the year where negative values happen, and also how long it lasts for.

I have tried using INDEX, MATCH, FREQUENCY (in which transpose might have to be used because frequency works on vertical lists).

However, I just can't come up with a solution no matter how I try. I have attached the file within.

Please point me in the right direction.

Thanks!