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!


--
Domenic
------------------------------------------------------------------------
Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785
View this thread: http://www.excelforum.com/showthread...hreadid=499159