ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

¥uÅã¥Ü¨S¦³­«ÂЪº¸ê®Æ

¥»©«³Ì«á¥Ñ gong ©ó 2011-8-27 21:52 ½s¿è

°}¦C
f2{=IF(E2="","",MAX(($B$2:$B$20=E2)*$C$2:$C$20))}

»P7¼Óoobirdª©¥D®t¤£¦h
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

­É¥Î10¼Ó man65boy ¥Sªþ¥ó¤@¥Î
E2  ¤½¦¡
{=INDEX($B$2:$B$20,MATCH(,COUNTIF($E$1:E1,$B$2:$B$20),))&""}

F2 ¤½¦¡

=IF(E2="","",LOOKUP(1,0/(MAX((B$2:B$10=E2)*A$2:A$10)=(B$2:B$10=E2)*A$2:A$10),C$2:C$10))

TOP

        ÀR«ä¦Û¦b : ¤Ó¶§¥ú¤j¡B¤÷¥À®¦¤j¡B§g¤l¶q¤j¡A¤p¤H®ð¤j¡C
ªð¦^¦Cªí ¤W¤@¥DÃD