would this work for you?

My time data was in a6:a15, and corresponding prices in b6:b15. I
specified start of window in a20, and close of window in a21

=MAX(IF(A6:A15=A20,IF(A6:A15<=A21,B6:B15)))

this is an array formula so enter with control+shift+enter

you could do the same with the MIN function


--
duane


------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=561896