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

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

·PÁ¼ӥDa8350070 ¤j¤j¤§¦^µª,¨Ì±z¤è¦¡­×¥¿,¦b'¾P°â°O¿ý¿é¤J!B3¿é¤J'¤Q' §YÂI¿ïÀx¦s®æ¥k¤è¤§¤U©Ô¦¡½bÀY-->µ²ªG¤U©Ô²M³æ¥H'¤Q' ¶}ÀY¤§²M³æ-->OK
¦ýÄ~Äò¦A¸Õ¸Õ©ó B4 ¥¼¿é¤J§YÂI¿ïÀx¦s®æ¥k¤è¤§¤U©Ô¦¡½bÀY-->µ²ªG¤U©Ô²M³æ¦PB3 (¥H'¤Q' ¶}ÀY¤§²M³æ -->µLªkÅã¥Ü¥þ³¡²M³æ ???
¥t¥~,¦Û¤v·Qª¾¹D,¿z¿ï¦r¤¸¥i§_§ï¦¨2­Ó©Î¦h­Ó?...
liu5201 µoªí©ó 2011-6-22 11:36


Ãö©ó­×¥¿¤½¦¡ªº°ÝÃD:
³o¼ËÁÙ¬O¨Ï¥Î¤F¤@¶µ°²³]¡A´N¬O±ý¿é¤JªºÀx¦s®æªº«e¤@­ÓÀx¦s®æ¥²»Ý¬O§¹¾ã¿é¤J«áªºª¬ºA¡A¤]´N¬O»¡
¦bB2¿é¤J¡u¤Q¡vµM«á¦C¥X ¤Q¥þ¡B¤Q¬ü¡B¤Q¤À µ¥²M³æ®É¡A¥²»Ý¿ï¤@­Ó¨Ó¿é¤J¡A¤£¯à¥u«O¯d¡u¤Q¡v¦bB2¡A
§_«h¦bB3¿é¤J«e®ÉÁÙ¬O·|¥H¤Q¬°ÃöÁä¦r§@¿z¿ï¡A¦Ó¤£¬OÅã¥Ü¥þ³¡²M³æ¡F³o¬O¾¨¶q¤£¨Ï¥Î¥¨¶°¨Ó¹F¦¨ªº§@
ªk¡A¦pªG·Q¯}°£³o¨Ç­­¨îÁÙ¬O±o¾a¥¨¶°¨Ó¹F¦¨¤~¦æ(¨Ï¥Î¥¨¶°ªº¸Ñ¨M¤è®×¤p§Ì¤w©ó1¼Ó©«¤l¤¤½s¿è»¡©ú)¡C

¿z¿ï¦r¤¸¬O¤£­­©w¦r¼Æªº¡A±z¥i¥H¦b°ò¥»¸ê®Æ¤¤¸m¤J³o¨Ç¤ñ¸ûÃþ¦üªº¦WºÙ´ú¸Õ¬Ý¬Ý
My Blog
http://blog.xuite.net/a8350070

TOP

¦³ÂI§Þ³N°ÝÃD,²Ä3ÂI¬O§_¦b"°ò¥»¸ê®Æ"ªº«È¤á¦WºÙ¸s·í¤¤,§ä¥X²Å¦X'¾P°â°O¿ý¿é¤J'¤½¥q¦WºÙªºµ{¦¡?

ÁÙ¦³²Ä5ÂI ...
FAlonso µoªí©ó 2011-6-24 09:53


¨BÆJ3ªº¤½¦¡¥¿¬O±N¡u°ò¥»¸ê®Æ!BÄæ¡v¤¤²Å¦XÃöÁä¦r±ø¥óªº¸ê®Æ¦C¥Ü¦b¡u¿z¿ï!BÄæ¡v¤¤¡C
   
¨BÆJ5ªº¤½¦¡¥Øªº¦b©ó¨ú±o¿z¿ï«á¦C¥Ü¦b¡u¿z¿ï!BÄæ¡v¤¤ªº¸ê®Æ½d³ò¡A¦ý¬O¦]¬°ÅçÃÒ²M³æ¨Ã¤£¯àª½±µ°Ñ·Ó¦Û¸ó¤u§@ªíªº¸ê®Æ¨Ó·½¡A©Ò¥H¥ÎINDIRECT¨ç¼Æ±N  ¿z¿ï!B1  µ¥°Ñ·Ó¨Ó·½¥]¸Ë°_¨Ó¡A³o¼Ë´N¯à¦¨¥\°Ñ·Ó¤F
My Blog
http://blog.xuite.net/a8350070

TOP

¦^´_ 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

¦^´_ 13# ANGELA


¥ÎINDIRECTµ¥¨ç¼Æ©Î©w¸q¦WºÙªº¤è¦¡§¡¥i¨ÏÅçÃÒ²M³æ°Ñ·Ó¨ì¨ä¥L¤u§@ªí,¬°¤è«K
¨BÆJ»¡©ú¤§¬G,±Ä¥ÎINDIRECT¨ç¼Æªº¤è¦¡

¦³Ãö   "¨S¿é¤JÃöÁä¦r®É¯à¿z¿ï¥X¥þ³¡²M³æ,¿é¤J¯S©w¦r«á¿z¿ï¥X¯S©w¦r"  ³oÂI,
¤p§Ì¤é«e¤w©ó1¼Ó©«¤l¤¤ªºPS3½s¿è»¡©ú¦p¤U

¦b¥¼¿é¤JÃöÁä¦r«e¨ÃµLªkÅã¥Ü¥þ³¡²M³æ¨ÓÂI¿ï¿é¤J¡A¸Ñ¨M¤è¦¡¬°¡G±N¨BÆJ5ªº¤½¦¡§ï¬°
¡@¡@¡@¡@=IF(COUNTIF(INDIRECT("°ò¥»¸ê®Æ!B:B"),LOOKUP(REPT("ù¡",255),INDIRECT("¾P°â°O¿ý¿é¤J!B:B"))),OFFSET(INDIRECT("°ò¥»¸ê®Æ!B2"),,,SUMPRODUCT(--(INDIRECT("°ò¥»¸ê®Æ!B1:B100")<>""))-1),OFFSET(INDIRECT("¿z¿ï!B1"),,,SUMPRODUCT(--(INDIRECT("¿z¿ï!B1:B100")<>""))))¡@¡@¡@¡@¡@¡@¡@¡@
¦ý³o¼ËÁÙ¬O¨Ï¥Î¤F¤@¶µ°²³]¡A´N¬O±ý¿é¤JªºÀx¦s®æªº«e¤@­ÓÀx¦s®æ¥²»Ý¬O§¹¾ã¿é¤J«áªºª¬ºA¡A¤]´N¬O»¡
¦bB2¿é¤J¡u¤Q¡vµM«á¦C¥X ¤Q¥þ¡B¤Q¬ü¡B¤Q¤À µ¥²M³æ®É¡A¥²»Ý¿ï¤@­Ó¨Ó¿é¤J¡A¤£¯à¥u«O¯d¡u¤Q¡v¦bB2¡A
§_«h¦bB3¿é¤J«eÁÙ¬O·|¥H¤Q¬°ÃöÁä¦r§@¿z¿ï¡A¦Ó¤£¬OÅã¥Ü¥þ³¡²M³æ¡F³o¬O¾¨¶q¤£¨Ï¥Î¥¨¶°¨Ó¹F¦¨ªº§@
ªk¡A¦pªG·Q¯}°£³o¨Ç­­¨îÁÙ¬O±o¾a¥¨¶°¨Ó¹F¦¨¤~¦æ¡C

¦Ü©ó¹B¥Î¥¨¶°¨Ó§ïµ½¥²»Ý¥Ñ¤W¦Ó¤U¨Ì§Ç¿é¤J¤Î¥¼¿é¤JÃöÁä¦r«eµLªkÅã¥Ü¥þ³¡²M³æ¤§¤è¦¡,
¤é«e¥ç¤w©ó1¼Ó©«¤l¤¤ªº¸É¥R¨BÆJA~F§@½s¿è»¡©ú

¨Ï¥Î¥¨¶°ªº½d¨ÒÀÉ
ÃöÁä¦r¿é¤J½d¨Ò-¨Ï¥Î¥¨¶°¸Ñ°£­­¨î.zip (286.78 KB)
My Blog
http://blog.xuite.net/a8350070

TOP

¦^´_ 14# a8350070


    GOOD JOB.

TOP

¦^´_ 1# a8350070


   

§Ú§Ë±z±Ðªº¤èªk, ¤¤¤å¦rªº¸Ü¦³¦¨¥\, ¦ý­^¤åªº¸Ü, ´NµLªk§¹¦¨¡C
½Ð°Ý¦³¾A¥Î­^¤å¦rªºÃöÁä¦r¿é¤J¶Ü?  ·PÁÂ!

TOP

¦^´_ 16# yc1031


¥»§Þ¥©À³¸Ó¤¤­^¤å³£¯à¾A¥Î³á

¦Ó¥B¦b¨BÆJ3ªº¤½¦¡¤¤
=IF(SUM(--ISNUMBER(SEARCH(A$1,°ò¥»¸ê®Æ!B$1:B$100)))<ROW(),"",INDEX(°ò¥»¸ê®Æ!B:B,SMALL(IF(ISNUMBER(SEARCH(A$1,°ò¥»¸ê®Æ!$B$1:$B$100)),ROW($A$1:$B$100)),ROW())))
¨Ï¥Î¤FSEARCH¨ç¼Æ,¯à¤£°Ï¤À­^¤å¤j¤p¼g§¡¯Ç¤J¿z¿ï½d³ò¤º
¦p±ý°Ï¤À¤j¤p¼g,«h»Ý±NSEARCH¨ç¼Æ§ï¦¨FIND¨ç¼Æ
My Blog
http://blog.xuite.net/a8350070

TOP

¯uªº¬O«Ü¼F®`ªº§Þ¥©

TOP

¸ê®ÆÅçÃÒ, Åã¥Ü"¿é¤Jªº­È¤£¥¿½T".
¤£ª¾¬O­þ¸Ì¿ù¤F. ³Â·Ð°ª¤â­Ì¬Ý¤@¤U¨Ã«ü¥¿.
·P®¦!!

ÃöÁä¦r¿é¤J½d¨Ò R1.zip (126.36 KB)

fangac

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

        ÀR«ä¦Û¦b : §Ú­Ì­n°µ¦nªÀ·|ªºÀô«O¡A¤]­n°µ¦n¤º¤ßªºÀô«O¡C
ªð¦^¦Cªí ¤W¤@¥DÃD