°Ñ·Ó­t¼Æªº³Ì¤j­È¨DAA2:AA4ªº¤½¦¡

myleoyes

¦U¦ì«e½ú§A­Ì¦n!
         «e½ú!!°ÝÃD¦pªþÀÉ»¡©ú
         ½Ðª¾¹Dªº«e½ú,¤£§[½ç±ÐÁÂÁ¦A¤T!!

ANGELA

AA2=INDEX(A:A,MATCH(MAX(IF(E3:E1443<0,E3:E1443)),E1:E1443,),) °}¦C¤½¦¡
AA4=IF(VLOOKUP(AA2,A:C,3,),VLOOKUP(AA2,A:C,3,),100)

gong

{aa2=INDIRECT("A"&INDEX($A$3:$A$1443,MATCH(1,--($E$3:$E$1443<0),0))+2)}

{aa3=INDIRECT("b"&INDEX($A$3:$A$1443,MATCH(1,--($E$3:$E$1443<0),0))+2)}

aa4=LOOKUP(2,1/INDIRECT("c3:c"&968+2),INDIRECT("c3:c"&968+2))

myleoyes

¦^´_ 3# gong
gong«e½ú!
ANGELA «e½ú!
       ¨â¦ì«e½ú!!AA4ªº¤½¦¡¦³»~
       ¦AªþÀÉ®×»¡©ú¨¯­WÅo!ÁÂÁ¦A¤T!!

gong

{=LOOKUP(2,1/INDIRECT("c3:c"&MATCH(1,--($E$3:$E$1443<0),0)+2),INDIRECT("c3:c"&MATCH(1,--($E$3:$E$1443<0),0)+2))}

Hsieh

©w¸q¦WºÙx
=MATCH(MAX(IF($E$3:$E$970<0,$E$3:$E$970,"")),E:E,0)

AB2=INDEX(A:A,x)
AB3=INDEX(B:B,x)
AB4=LOOKUP(9.9E+307,OFFSET($C$2,,,x-1,))

myleoyes

¦^´_ 6# Hsieh
Hsieh«e½ú!
gong«e½ú!
       ¨â¦ì«e½ú!!¨¯­WÅo!ÁÂÁ¦A¤T!!