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

[µo°Ý] ¦p¦ó§Q¥Î¤wª¾Äæ¦ì¦Û°Ê¦C¥X¹ïÀ³¸ê®Æ©ó©T©wªí®æ¤¤¡]¤w¸Ñ¨M¡^

[µo°Ý] ¦p¦ó§Q¥Î¤wª¾Äæ¦ì¦Û°Ê¦C¥X¹ïÀ³¸ê®Æ©ó©T©wªí®æ¤¤¡]¤w¸Ñ¨M¡^

¥»©«³Ì«á¥Ñ onegirl0204 ©ó 2011-8-14 17:24 ½s¿è

¦pªþ¥ó©Ò¥Ü ­ÓºÞ¹ïÀ³¾Ç¥Í.rar (2.74 KB)
½Ð°Ý¡G¦p¦ó§Q¥Îsheet2 C3¤wª¾ªº­ÓºÞ¦Ñ®v¦W¦r¡A§Q¥Î¨ç¼Æ±a¥X¹ïÀ³ªº¸ê®Æ¦Û°Ê¦C©óA5:C11ªºªí®æ¤¤¡A­YµL¹ïÀ³¸ê®Æ¤F´N¥X²{ªÅ¥Õ§Y¥i
·P®¦¦U¦ì«e½ú«ü±Ð¡AÁÂÁ¡I

SHEET2!A5=INDEX(Sheet1!$B$1:$B$11,SMALL(IF(Sheet1!$D$2:$D$10=$C$3,ROW($2:$10),11),ROW(A1)))&""
¨ä¾l½Ð°Ñ¦ÒA5

TOP

¦^´_ 2# ANGELA


·PÁ±zªº«ü±Ð¡I¤w¦¨¥\¦C¥X¢Ï¢´¡ã¢Ñ¢´ªº¹ïÀ³¸ê®Æ¡A¦ý¤£ª¾¬°¦ó©¹¤U¡]¢Ï¢µ¡D¡D¡D¡D¡^½Æ»s®É¡A«o¥X²{°ÝÃD¡ã ­ÓºÞ¹ïÀ³¾Ç¥Í-1.rar (2.95 KB)
·Ð½Ð±z¦A¦¸½ç±Ð¡A·P®¦¡I

­ÓºÞ¹ïÀ³¾Ç¥Í-1.rar (2.95 KB)

TOP

¦^´_ 3# onegirl0204


    °}¦C¤½¦¡»Ý¦P®É«ö ctrl+shift+enter

TOP

¦^´_ 4# ANGELA

·PÁª©¥D±zªº«ü±Ð¡I¦b¤U·M¬N¡A§Ë¤F¦n¤[¤~²×©ó»â®©¤F¡I­è­è¬ðµM·Q°_¡A¦³¥i¯à·|¦³·sªº¾Ç¥Í¥[¤J¡A©ó¬O¸ÕµÛ¦b­ì¥»ªº²Ä¢¸¦C»P²Ä¢°¢¯¦C¤S·s¼W¤@µ§¸ê®Æ¡AªGµMªí®æ¤ºªº¸ê®Æ¤S¿ù¤F¡I¬°¤F¹w¨¾·s¼W¸ê®Æªº¥i¯à©Ê¾É­P¸ê®Æ¿ù»~¡A¯à§_¤£³]©wSHEET1ªº¦C¼Æ¡H¦p¦ó­«·s­×§ï¤½¦¡¡A½Ðª©¥D¦A¦¸½ç±Ð¡A·P®¦¡I

TOP

¦^´_ 5# onegirl0204
°ÊºA½d³ò
§Ú²ßºD¼g¤J¦WºÙ¨Ï¥Î¡A¦pªþ¥ó
­ÓºÞ¹ïÀ³¾Ç¥Í.zip (7.28 KB)
SHEET3¨Ï¥Î¼Ï¯Ã¤ÀªR¨Ñ°Ñ¦Ò
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

RE: ¦p¦ó§Q¥Î¤wª¾Äæ¦ì¦Û°Ê¦C¥X¹ïÀ³¸ê®Æ©ó©T©wªí®æ¤¤¡]¤w¸Ñ¨M¡^

¦^´_ 6# Hsieh


ÁÂÁ¶W¯Åª©¥D½ç±Ð¡I­è­è¸Õ¹L¥ô·N´¡¤J¤@µ§·s¸ê®Æ¤w¸g·|¦Û°Ê§ó·s¤F¡Aê©óªí®æ¥t¦³ªíÀY¤Î¨ä¥L»¡©ú¡A®æ¦¡µLªk±Ä¥Î¼Ï¯Ã¤ÀªRªíªº¤è¦¡¡AµL½×¦p¦ó¤´µM«D±`·PÁ±zªºÀ°¦£¡A·P®¦¡I

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡µLªk¾B¾×¡j©È®É¶¡®ø³u¡Aªá¤F³\¦h¤ß¦å¡A·QºÉ¦U¦¡¤èªk­n¾B¾×®É¶¡¡Aµ²ªG¬O¡G®ö¶O¤F§ó¦h®É¶¡¡A¥B¤@µL©Ò¦¨¡I
ªð¦^¦Cªí ¤W¤@¥DÃD