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

[µo°Ý] ·j´M¬ÛÃö¸ê®Æ

[µo°Ý] ·j´M¬ÛÃö¸ê®Æ

§Ú·Q­n¦bsheet1·j´Msheet2¸ê®Æ
¦p¦³¬ÛÃö¦r´N·|Åã¥Ü¦bsheet1¤º
½ÐÀ°¦£

001.zip (1.88 KB)

¥»©«³Ì«á¥Ñ Hsieh ©ó 2012-7-4 23:29 ½s¿è

¦^´_ 1# sheau-lan

Sheet1!A3°}¦C¤½¦¡
=IF(ROW(A1)>SUMPRODUCT(ISNUMBER(FIND($B$1,Sheet2!$A$2:$A$6))*1),"",OFFSET(Sheet2!$A$1,SMALL(IF(ISNUMBER(FIND(Sheet1!$B$1,Sheet2!$A$2:$A$6)),ROW($2:$6),""),ROW(A1))-1,COLUMN(A$1)-1))
¦V¥k¦V¤U½Æ»s

¶i¶¥¿z¿ï¤]¬O«Ü¦nªº¿ï¾Ü
    play.gif
¸ê®Æ¬d¸ß¤]¦æ
play.gif
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

°}¦CÀ³¸Ó¬O§Ú·Q­n£xµ²ªG.¤£¹L¸ê®Æ¶]°_¨Ó·|ºC¤@ÂI
¶i¶¥£x¸Ü´N³Â³Â¤@ÂI¨C¦¸³£­n¿z¿ï¤@¦¸
¸ê®Æ¬d¸ß£x¤è¦¡§Ú°µ¹L£{¤£¹L¤£ª¾¹D­þ¥X£{®t¿ù.¹L¤@¬q´Á¶¡¸ê®Æ´N·|¶]±¼£{.¬d¤£¥X¨Ó.³£·|¸ò§Ú»¡¨S¦³³sµ²
¤£¹L³o¦¸£x°}¦C»P§Ú¤§«e³]©w£x¦³¤@¨Ç¤£¤@¼Ë.©Ò¥H§Ú¸Õ¸Õ¬Ý¦n¤F
ÁÂÁÂHsieh¤j¤j´£¨Ñ£{§Ú¨º£v¦h£x¸ê°T

TOP

        ÀR«ä¦Û¦b : µoµÊ®ð¬Oµu¼ÈªºµoºÆ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD