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

[µo°Ý] ¦p¦ó¦Û°Ê¦C¥X±Ð®v±Â½Ò¦W³æ

[µo°Ý] ¦p¦ó¦Û°Ê¦C¥X±Ð®v±Â½Ò¦W³æ

¦pªþ¥[Àɤºªº»¡©ú¡A ±Ð®v±Â½Ò¦W³æ.rar (3.96 KB) ½Ð°Ý¡G¸Ó¦p¦ó¦b¢Ú¡®¢ÛÄæ³]¥ß¤½¦¡¡A·í¢Ù¢±¥´¤J¥Ò¦Ñ®vªº¦W¦r¡A¬Û¹ïÀ³¥L±Ðªº¾Ç¥Í¯Z¯Å¤Î©m¦W·|¦Û°Ê¥X²{¡H¥ç§Y¨C¦ì¦Ñ®v©Ò±Ðªº¾Ç¥Í¦W³æ¦Û°Ê¦C¥X¨Ó°Õ¡I
ÁÂÁ«ü±Ð¡I

·s¤B©Ò¾Ç¤£¦h¡A¥u·|¥Î¦¹¤èªk¡A­Y¤£¶û²Ê¦H¡A¥i§@°Ñ¦Ò¡I

±Ð®v±Â½Ò¦W³æ.rar (9.83 KB)

TOP

L2°}¦C¤½¦¡
=IF(ROW(A1)>COUNTIF($C$2:$C$25,$K$2),"",INDEX(A:A,SMALL(IF($C$2:$C$25=$K$2,ROW($2:$25),""),ROW(A1))))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

Hsieh¤j¤jªº¥\¤O¡A·s¤B¥R¤ß¨ØªA¡I
¤@¤ñ¤§¤U¡A¯u¦³ÂIµL¦a¦Û®e¡I¡I

TOP

¦^´_ 4# trainee
¦¹¨¥®t¨o!
¶i¶¥¿z¿ï¤~¬O¥¿¹D
°}¦C¨ç¼Æ­Y¬O¹J¨ì¤j¸ê®Æ¶q®É±N³y¦¨¤û¨B
¥u¬O´£¥X¨Ó¨Ñ¤j®a°Ñ¦Ò¦Ó¤w
­n¦b¹ê°ÈÀ³¥Î§Ú¤]¬O±ÀÂ˶i¶¥¿z¿ï
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 5# Hsieh


    ·P¿EHsieh¤j¤jªº¦^´_¡I:)

TOP

¦^´_ 2# trainee


·PÁ±zªº¦^ÂСI¦ý¥i§_±N¦³Ãöªº³]©w¦C¥X¨Ó¨Ñ§Ú¾Ç²ß¤§¥Î©O¡H¦Ñ¬O¦Y§O¤H³¨ªº³½®£«Dªø¤[¤§­p§r¡I·P®¦±z¡I

TOP

¦^´_ 3# Hsieh


ÁÂÁ±zªº«ü±Ð¡I½Ð§iª¾¥i¥H¾Ç²ß¨ì¬ÛÃöªº±Ð¾Çºô§}¡A¦n¶Ü¡H·P®¦±z¡I

TOP

ss.gif

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2011-7-10 23:46 ½s¿è

¦^´_ 8# onegirl0204

chin15¦b9#¤w¸g¦^´_±o«Ü²M·¡¡A¶i¶¥¿z¿ï¬O«Ü¦nªº°ò¥»¾Þ§@
2#trainee ªº§@ªk¥u¬O±N¶i¶¥¿z¿ï°Ê§@¥ÎVBA¨Ó¶i¦æ
¦Ó³Ì®tªº´N¬O§Ú¥Î°}¦C¤½¦¡¨Ó§¹¦¨
¦Ü©ó¤½¦¡ªº§@ªk¡A¨S¦³¬Æ»ò¯S§Oªº
°ß¦³¹ï¦U­Ó°ò¥»¨ç¼Æ¤F¸Ñ«á
°w¹ï­Ó®×»Ý¨D¥h«ä¦Ò
§A­n±q§O¤Hªº¤½¦¡¤¤¥h¤F¸Ñ­Ó¨ç¼Æªº§@¥Î
¾ã²z¥X¬Æ»òª¬ªp¦³­þ¨Ç¨ç¼Æ¯à¬£¤W¥Î³õ
µM«á·Q¿ìªk±q¤wª¾ªº±ø¥ó¥h¨D±o­Ó¨ç¼Æªº¤Þ¼Æ
¥H¦¹¨Ò=IF(ROW(A1)>COUNTIF($C$2:$C$25,$K$2),"",INDEX(A:A,SMALL(IF($C$2:$C$25=$K$2,ROW($2:$25),""),ROW(A1))))
COUNTIF($C$2:$C$25,$K$2)·N¦bºâ¥X²Å¦X±ø¥óªº­Ó¼Æ
¦pªG¦C¸¹¶W¥X­Ó¼Æ´NÅýÀx¦s®æÅã¥Ü¬°ªÅ¦r¦ê
SMALL(IF($C$2:$C$25=$K$2,ROW($2:$25),""),ROW(A1))
³o¬O±qCÄ椤§ä¨ì²Å¦X±ø¥óªº¦ì¸m´N¶Ç¦^¸Ó¦C¸¹§_«h¶Ç¦^ªÅ¦r¦ê¡A³o¤@³s¦êªº¼Æ¦r»PªÅ¦r¦ê¤¤¡A§ä¨ì³Ì¤p¼Æ­È
©Ò¥H·í¤½¦¡¦V¤U½Æ»s®ÉROW(A1)·|Åܦ¨ROW(A2)¡A´N¶Ç¦^²Ä2¤pªº¼Æ­È
¦A§Q¥ÎINDEX¥h§ä¨ìAÄ檺²Ä´X¦C§@¬°¶Ç¦^ªºµ²ªG
§A¥i§Q¥Î¤½¦¡½]®Ö¨Ó¬d¬Ý¾ã­Ó¤½¦¡ªº¹B§@¶¶§Ç
´N·|¼W¶i§Aªº«ä¦Ò¯à¤O
©Ò¥H­n»¡±q­þ¸Ì¾Ç²ß¡A¥»½×¾ÂÀ³¸Ó¬O­Ó¤£¿ùªº¦a¤è
¦ý¬O¡A³Ì«áÁÙ¬O­n¥Ñ¦Û¤vªº«ä¦Ò¨Ó§¹¦¨
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ½_ÁJµ²±o¶V¹¡º¡¡A¶V·|©¹¤U««¡A¤@­Ó¤H¶V¦³¦¨´N¡A´N­n¶V¦³Á¾¨Rªº¯ÝÃÌ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD