Days between peaks

[cloobless]

Hi, I'm seeking a solution for conditionally counting the days between max values.

In the example below, I'm trying to construct a conditional formula for the "DaysUnderPeak" column. This column would output the text "new peak" if the "Peak"(B) value is higher than the previous Date's(A) peak value. If the new peak is the start of a sequence of days where the peak value is unchanged, the output would numerically increment until a new peak is measured.

Note that the first peak in any sequence is always the text "new peak", not "1".

I colored and outlined the data below to help explain what I'm trying to do. Any help or suggestions would be most welcomed. Thank you very much for taking a look.

 

[JLGWhiz]

put this in E3 and drag down as needed.

=IF(B3=B2,IF(E2="New Peak",2,E2 + 1),"New Peak")

 

[cloobless]

Holy moly, that is neat. Thank you so much, JLGWhiz. l think I was a long way from doing it correctly. Thank you for taking the time to help me out. I appreciate it.

 

[JLGWhiz]

Holy moly, that is neat. Thank you so much, JLGWhiz. l think I was a long way from doing it correctly. Thank you for taking the time to help me out. I appreciate it.

No problem, glad you could use it.
Regards, JLG

 

[cloobless]

Before asking for more help I gave this shot for most of the morning. I failed and I'm back. I hoping someone or JLG might see this.

Is there a way to identify the low value in each sequence of "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.