Probably pretty basic question - only starting t play with excel - simple data set - daily nasdaq prices in descending data order; looking to report the number of days it takes to get back to equal or greater price after two consecutive drops - so for 3/8, second drop was 13 points - want to put function in next column by counting number of cells up from 7421.46 to the next occurrence of a value greater than it - i.e. 7558 answer is 2. Having a hard time conceptualizing how to approach this. any help appreciated.
<tbody>
</tbody>
3/11/19 | 7,558.06 | ||
3/8/19 | 7,408.14 | ||
3/7/19 | 7,421.46 | 13 | 2 |
3/6/19 | 7,505.92 |
<tbody>
</tbody>