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!
Bookmarks