I forgot to limit the upper range. (Old spreadsheet searches for data
out of the spreadsheet range if the search range goes too high and
yields incorrect result.) Here is a new one.


Hope it helps.


+-------------------------------------------------------------------+
|Filename: Min Max.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3604 |
+-------------------------------------------------------------------+

--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=387512