Thanks to everyone for your rapid responses. QED! -Gwen :
A Aladin Akyurek Oct 30, 2004 #2 Gwen, Replace the formula in E50 in the system I posted with: =MAX(IF(INDEX(B52:B59,MATCH(E49,C52:C59,0))=B52:B59,C52:C59))-E49 which must be confirmed with control+shift+enter instead of just wit enter.
Gwen, Replace the formula in E50 in the system I posted with: =MAX(IF(INDEX(B52:B59,MATCH(E49,C52:C59,0))=B52:B59,C52:C59))-E49 which must be confirmed with control+shift+enter instead of just wit enter.
