Forum Discussion
Formula to see how often and how long something happens?
Please check in attached. You need to drag cells from three columns at once.
Could you please clarify why in your sample you marked as first crisis end of first episode, not it's beginning, and same for other columns.
Dear Sergei,
thank you for looking into this.
For instance, please look at the first case below.
The episode when GDP was above 3% was first between 1872-1876. The first crisis happened in 1877 (Column J). This is the next year the episode of 3% growth ended.
Therefore, from the columns L-M-N-O, I would like "1" to be at 1877 under Column O. The logic is that I first look at when the crisis happened (Arrow A). Then I look how does it corresponds to the conditions at columns L-M-N-O (that is Arrow B). And this then allocates the "1" to Column O.
Similar rational I present for the remaining Columns below.
Thank you for the explanation. But when next numbers( 1 in column J in rows 1892,1897,1899,1901) are not clear. Is next sequence of crises (for next years) repeats this logic or not?