Finding lowest low in a pullback

[sam mcgee]

In a series of rising pricebars for a stock, I'm trying to find the value of the lowest low in a pullback. I have to find this low value separate from price bars that preceded the pullback.

The maximum number of bars I look back is 6, but in those 6 bars there may be lower lows before the pullback started. The pullback starts when one of the highs is lower than the previous high.

I've attached pictures to clarify what I'm trying to do. Does anyone have any ideas? Thank you for your help.

[Domenic]

Try...

=IF(COUNTIF(D2:INDEX(D2:D9,MATCH(2,1/(D2:D9=MAX(D2:D9)))),"<"&MAX(D2:D9)),MIN(D2:INDEX(D2:D9,MATCH(2,1/(D2:D9=MAX(D2:D9))))),"No Lessor Values after Peak")

...confirmed with CONTROL+SHIFT+ENTER, not just ENTER. Adjust the range accordingly.

Hope this helps!