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

[¤À¨É] ²³æ§Þ¥©¤À¨É-ÃöÁä¦r¿é¤J

¦^´_ 12# a8350070


    ¥Î©w¸q¦WºÙªº¤è¦¡§Y¥i°Ñ·Ó¨ì¨ä¥L¤u§@ªí¤F,ÁÙ¦³¦pªG¦b¨S¿é¤JÃöÁä¦r®É¯à¿z¿ï¥X¥þ³¡²M³æ,¿é¤J¯S©w¦r«á¿z¿ï¥X¯S©w¦rªº¤½¥q¦WºÙ·|§ó²z·Q.

TOP

¦^´_ 14# a8350070


    GOOD JOB.

TOP

¥»©«³Ì«á¥Ñ ANGELA ©ó 2012-10-3 13:59 ½s¿è

¨â­Ó°ÝÃD
1¸ê®ÆÅçÃÒªº¿ù»~´£¿ô­nÃö±¼¡C
2¿z¿ïb1=IF(SUM(--ISNUMBER(SEARCH(A$1,Data!C$1:C$100)))<ROW(),"",INDEX(Data!C:C,SMALL(IF(ISNUMBER(SEARCH(A$1,Data!$C$1:$C$100)),ROW($A$1:$B$100)),ROW())))
½d³ò­n¤@­P
³Ì¦n«Ø¥ß°ß¤@­Èªº«È¤á²M³æ

TOP

¸ê®Æ¶q¤j®É¡A¡]¤×¨ä¬O°}¦C¤½¦¡¡^¡A¥Î¢ä¢Ð¢Ï·|¤ñ¸û²z·Q¡C©w¸q¦WºÙ¦³À°§U¡A¦ý¤£¤j¡C

TOP

        ÀR«ä¦Û¦b : ¤£­nÀH¤ß©Ò±ý¡A­nÀH¤ß±Ð¨|¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD