Gwen,
Replace the formula in E50 in the system I posted with:
=MAX(IF(INDEX(B52:B59,MATCH(E49,C52:C59,0))=B52:B5 9,C52:C59))-E49
which must be confirmed with control+shift+enter instead of just with
enter.
Gwen Frishkoff Wrote:
Thanks to everyone for your rapid responses. QED! -Gwen :)
--
Aladin Akyurek
------------------------------------------------------------------------
Aladin Akyurek's Profile:
http://www.excelforum.com/member.php...fo&userid=4165
View this thread:
http://www.excelforum.com/showthread...hreadid=273889