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

[µo°Ý] ­û¤u½Ð°²¤é´Áªº¬d¸ß?

¥»©«³Ì«á¥Ñ fr447446 ©ó 2011-5-26 11:36 ½s¿è

ANGELAª©¥D ¦b5¼Óªº®É­Ô¦³»¡¤F...

°}¦C¤½¦¡

¤½¦¡¿é¤J§¹«á¡A½Ð«ö¤U Ctrl+Shift+Enter..
¨S¨Æ´N¨Ó³}³}

TOP

¥»©«³Ì«á¥Ñ fr447446 ©ó 2011-5-27 17:00 ½s¿è

B3=IF(COUNTIF(¸ê®Æ®w!$B$2:$H$32,$A3)>=COLUMN(A$1),SMALL(IF(¸ê®Æ®w!$B$2:$H$32=¬d¸ß!$A3,¸ê®Æ®w!$A$2:$A$32),COLUMN(A$1)),"")
°}¦C¤½¦¡
§Q¥Î¤§«eHª©¥Dªº¥Îªk§ï¼g¤@¤U~
¨S¨Æ´N¨Ó³}³}

TOP

        ÀR«ä¦Û¦b : ºw¤ô¦¨ªe¡C²É¦Ì¦¨ÅÚ¡A¤Å»´¤vÆF¡A¤Å¥Hµ½¤p¦Ó¤£¬°¡C
ªð¦^¦Cªí ¤W¤@¥DÃD