Subject: Re: New Highs and New Lows
A slight correction-
Column F
=IF(C14=MIN(C14:C20),1,0)
=IF(C14=MAX(c14:OFFSET(C14,$K$1,0,1,1)),1,0)
should be
Column F
=IF(C14=MIN(C14:C20),1,0)
=IF(C14=
MIN
(C14:OFFSET(C14,$K$1,0,1,1)),1,0)