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

[µo°Ý] ³æÄæ¸ê®ÆÂà¦h¦C

[µo°Ý] ³æÄæ¸ê®ÆÂà¦h¦C

¦U¦ì¤j¤j~
¤£¦n·N«ä~·Q½Ð°Ý­Ó°ÝÃD
¦]¬°§Ú±q«e¤H¨º¹F¨ì¤@¥÷¸ê®Æ
¥Ø«e»Ý­n¥ÎùØÀYªº¸ê®Æ°µ¼Ï¯Ã¤ÀªR
¦ý¬O«e¤Hªº¸ê®Æ¦³ªº¬O³æÄæ¸Ì¦³¦hµ§¸ê®Æ
Ãþ¦ü¤U¹Ï½d¨Ò

¦Ó¥Bµ§¼Æ¬O¶W¯Åªº¦h~~~~
©Ò¥H·Q½Ð°Ý­Y§Ú·Q±N¸ê®Æ®i¦¨¹Ï¤¤½bÀY¥kÃ䪺¸Ü
¦³¤ñ¸û¦nªº¤èªk©Î¨ç¼Æ¥i¥Î¶Ü????
ÁÙ¬OµL¸Ñ~¥²¶·¤@µ§¤@µ§®i©O~~~~
«ô°U¦³¸gÅ窺¤j¤jÀ°¦£
¥ý·P¿E¦U¦ì¤j¤j¤F

¢Ò¢²¡G¤U©Ô
=LEN(B3)-LEN(SUBSTITUTE(B3,CHAR(10),))+(B3<>"")+D2

¢Ô¢²¡G¤U©Ô
=LOOKUP(ROW(A1)-1,--D$2:D$5,A$3:A$6)&""

¢Õ¢²¡G¥k©Ô¦A©¹¤U¨ê
=TRIM(MID(SUBSTITUTE(LOOKUP(ROW($A1)-1,--$D$2:$D$5,B$3:B$6),CHAR(10),REPT(" ",99)),COUNTIF($F$2:$F2,$F3)*99+1,99))

TOP

http://blog.xuite.net/hcm19522/twblog/357874794

TOP

¦^´_ 2# ­ã´£³¡ªL
·PÁ­㴣³¡ªL¤jªº«ü¾É¡ã¡ã¡ã
¦ý¬O§Ú¥u°µ¥X¤F¤@³¡¥÷¡ã¦p¤U¹Ï

§Ç¸¹3ªº³¡¤ÀRUN¤£¥X¨Ó
¤£ª¾§Ú¬O§_¦³°µ¿ùªº¦a¤è©O¡H¡H¡H
Àµ½Ð­ã´£³¡ªL¤j¤j¦b«ü¾É¤@¤U
·P¿E¡ã¡ã¡ã¡ã

TOP

¦^´_ 4# dodo234


¸ê®Æ®æ¦¡¤£¤@¼Ë¡A¤½¦¡¬O¥H¡e³æ¤@®æ¡f©ñ¤@¦Ü¦h­Ó¸ê®Æ¬°·Ç¡A
¤W¶Ç½d¨ÒÀɧa¡I

TOP

¦^´_ 5# ­ã´£³¡ªL
EXCEL.zip (1.42 KB)
Àµ½Ð­ã´£³¡ªL¤j¨ó§U¡ã
¦ý¬O§ÚÅv­­¤£°÷¡ã¥i¯à¨Sªk¤U¸ü±z§ïªº¹LªºÀÉ®×
¥i§_½Ð±z¦A±N¤½¦¡POµ¹§Ú§Ú¦A¸Õ¸Õ©M¬ã¨s¬Ý¬Ý©O¡H¡H¡H
ÁÂÁ±z¡ã¡ã¡ã¡ã¡ã

TOP

¦^´_ 6# dodo234


¢Ô¢²¡G
=LOOKUP(ROW(A1)-1,--D$2:D8,A$3:A8)&""

¢Õ¢²¡G
=TRIM(MID(SUBSTITUTE(LOOKUP(ROW($A1)-1,--$D$2:$D8,B$3:B8),CHAR(10),REPT(" ",99)),COUNTIF($F$2:$F2,$F3)*99+1,99))

°Ñ·Ó¦ì§}­n§ì¹ï¡ã¡ã

TOP

¦^´_  dodo234


¢Ô¢²¡G
=LOOKUP(ROW(A1)-1,--D$28,A$3:A8)&""

¢Õ¢²¡G
=TRIM(MID(SUBSTITUTE(LO ...
­ã´£³¡ªL µoªí©ó 2015-11-21 15:24


¥i¥H¤F¡ã¡ã¡ã¡ã¡ã
«D±`·P¿E­ã´£³¡ªL¤jªº«ü¾É¡ã¡ã¡ã¡ã§Ú¦A¨Ó¬ã¨s¬Ý¬Ý¡ã¡ã¡ã¡ã¡ã
¯uªº«D±`·PÁ±z¡ã¡ã¡ã¡ã

TOP

        ÀR«ä¦Û¦b : ¬°¦Û¤v§äÂǤfªº¤H¥Ã»·¤£·|¶i¨B¡C
ªð¦^¦Cªí ¤W¤@¥DÃD