Hi, there. I'm trying (unsuccessfully) to figure out how to calculate column L. Is there a way to identify the low value in each sequence of K "days under" data in something like the L column faked below? The formulas I returned don't seem to be checking the whole sequence, or identify the wrong value, or neither. Thank you to anyone who might see this.
The columns are:
F is the value on any given date
H looks for the highest peak value and keeps outputting it until a new peak comes
K is a count of days in a row that the F-value is still under the peak
L -- looks at all the sequential days' values under last peak and determines which is the lowest. This is the formula I cannot solve.
Any ideas for L? Thank you very much.
The columns are:
F is the value on any given date
H looks for the highest peak value and keeps outputting it until a new peak comes
K is a count of days in a row that the F-value is still under the peak
L -- looks at all the sequential days' values under last peak and determines which is the lowest. This is the formula I cannot solve.
Any ideas for L? Thank you very much.