§Q¥ÎExcel¤ñ¹ï¦hµ§¦³¤À¹j²Å¸¹¸ê®Æªº¬Û¦P³B
- ©«¤l
- 8
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 9
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- office2007
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2013-10-6
- ³Ì«áµn¿ý
- 2013-11-14
|
§Q¥ÎExcel¤ñ¹ï¦hµ§¦³¤À¹j²Å¸¹¸ê®Æªº¬Û¦P³B
½Ð°Ý¹³¤U¦C¦³¤À®æ²Å¸¹¦b¦P¤@Äæ¡A§Ú·Q¤ñ¹ï¤£¦PÄæ¦ì¬O§_¦³¬Û¦P(«ÂÐ)ªº¨Ã¥B«ÂЪº¥iÅܦ¨¬õ¦â(§Oªº¦â¤]¥i¥H)³oºØ¤½¦¡n¦p¦ó¼g??ÁÂÁÂ
C1,C2,C3,C4,C5...................
C5,C6,C7,C8..............
R5,R6,R7,R8.................
R12,R6,R17,R18...............
.
.
.
. |
|
|
|
|
|
|
- ©«¤l
- 618
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 663
- ÂI¦W
- 1
- §@·~¨t²Î
- WINDOWS 7
- ³nÅ骩¥»
- OFFICE 2013
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Pingtung
- µù¥U®É¶¡
- 2011-9-2
- ³Ì«áµn¿ý
- 2024-7-5
|
¥»©«³Ì«á¥Ñ p212 ©ó 2013-10-7 08:36 ½s¿è
¦^´_ 1# parker
¤£¤Ó©úÁA±zªº°ÝÃD¡A¥i¥H´£¨Ñ¤@¤U±znªº½d¨Òµª®×¤@°_¬ã¨s¡HÁÂÁ¡I(¦pªG¯à¶KExcel¤º®eµe±Äæ¦ì¤À¥¬»¡©ú§ó¦n) |
|
|
|
|
|
|
- ©«¤l
- 8
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 9
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- office2007
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2013-10-6
- ³Ì«áµn¿ý
- 2013-11-14
|
¥»©«³Ì«á¥Ñ parker ©ó 2013-10-7 20:26 ½s¿è
¦^´_ 2# p212
½ÐÀ°¦£¬ÝªþÀɪº¤å¥ó,³o¬O§ÚÌn«ØÀɪºBOMªí§Ú¥u§T¨ú¤Ö³¡¥÷¡A¶À¦âÄæ¦ì(¦ì¸m)¬O§Ú·Qn¦Û°Ê¤ñ¹ï¬O§_¦³«½Æ¤å¦r¡A¦]¬°¦³¤À¹j²Å¸¹©Ò¥H¤£ª¾¤½¦¡n¦p¦ó¼g¡Cºñ¦âÄæ¦ì(¼Æ¶q)¬O§Ú§Æ±æ¦Û°Êºâ¥X¶À¦âÄæ¦ì(¦ì¸m)¦³´XÓ¹s¥ó¡A©Ò¥H¤£ª¾¬O§_¦³¤½¦¡¥i§iª¾??
ÁÂÁÂ |
-
-
bom.zip
(1.6 KB)
|
|
|
|
|
|
- ©«¤l
- 618
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 663
- ÂI¦W
- 1
- §@·~¨t²Î
- WINDOWS 7
- ³nÅ骩¥»
- OFFICE 2013
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Pingtung
- µù¥U®É¶¡
- 2011-9-2
- ³Ì«áµn¿ý
- 2024-7-5
|
¥»©«³Ì«á¥Ñ p212 ©ó 2013-10-8 10:17 ½s¿è
¦^´_ 3# parker
ºñ¦âCÄæ¦ì(¼Æ¶q)ªºpºâ½Ð¨Ï¥Î¤U¦C¤½¦¡¡A¥H¦ì©óC2Àx¦s®æ¬°¨Ò¡G
=IF(D2="","",LEN(D2)-LEN(SUBSTITUTE(D2,",",""))+1)
¦V¤U½Æ»s¤½¦¡
¡i»¡©ú¡j
§Q¥ÎpºâDÄæÀx¦s®æ¤§¡u³r¸¹¼Æ¶q+1¡v§Y¥iÀò±oµª®×
1¡BLEN(D2)¡GpºâD2Àx¦s®æ즳¦r¼Æ
2¡BSUBSTITUTE(D2,",","")¡G§R°£D2Àx¦s®æ¤¤ªº³r¸¹¨Ï¦r¦ê¬°³sÄò¤£¤¤Â_
3¡BLEN(SUBSTITUTE(D2,",",""))¡Gpºâ§R°£D2Àx¦s®æ¤¤ªº³r¸¹«á³sÄò¦r¦êªº¦r¼Æ
4¡BLEN(D2)-LEN(SUBSTITUTE(D2,",",""))+1¡GD2Àx¦s®æ³r¸¹¼Æ¶q¦A¥[1§Y¬°½d¨ÒÀɤ¤ªº¡u¹s¥ó¡v¼Æ
½Ð°Ñ¦Ò¡I
¦Ü©ó¶À¦âÄæ¦ì(¦ì¸m)¦Û°Ê¤ñ¹ï³¡¥÷¡A«h¦³½Ð°ª¤â«ü¾É¡AÁÂÁ¡I |
|
|
|
|
|
|
- ©«¤l
- 8
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 9
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- office2007
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2013-10-6
- ³Ì«áµn¿ý
- 2013-11-14
|
¦^´_ 4# p212
·PÁ¤F½Ð°Ý¦³¨º¨Ç®Ñ¥»©Îºô¯¸¦³¦b±Ðexcelªº³o¨Ç¤½¦¡¼gªk???§Ú·Qn¦n¦n¾Ç²ß¬ã¨s¤@¤U. |
|
|
|
|
|
|
- ©«¤l
- 8
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 9
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- office2007
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2013-10-6
- ³Ì«áµn¿ý
- 2013-11-14
|
¦^´_ 4# p212
P212¤j¼w;
§Úèèkey¤J¤½¦¡¦bC2Äæ¦ì¸ÕÅçµoı¤£¦æ,ÅܪťյL¥ô¦ó¼Æ¦r???¬O§Ú¤½¦¡key¿ùÄæ¦ì¤F¶Ü??
ÁÂÁÂ |
|
|
|
|
|
|
- ©«¤l
- 618
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 663
- ÂI¦W
- 1
- §@·~¨t²Î
- WINDOWS 7
- ³nÅ骩¥»
- OFFICE 2013
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Pingtung
- µù¥U®É¶¡
- 2011-9-2
- ³Ì«áµn¿ý
- 2024-7-5
|
¥»©«³Ì«á¥Ñ p212 ©ó 2013-10-8 17:21 ½s¿è
¦^´_ 6# parker
½Æ»s4#¤§
=IF(D2="","",LEN(D2)-LEN(SUBSTITUTE(D2,",",""))+1)
³w¶K©ó±z´£¨Ñ½d¨Ò¤§C2Àx¦s®æ¡AOK¡I
YD2Àx¦s®æ¬°ªÅ¥Õ¡A«hC2Àx¦s®æ¥²¬°ªÅ¥Õ¡C
¦]¬° IF(D2="","",
½Ð°Ñ¦Ò¡I |
|
|
|
|
|
|
- ©«¤l
- 618
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 663
- ÂI¦W
- 1
- §@·~¨t²Î
- WINDOWS 7
- ³nÅ骩¥»
- OFFICE 2013
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Pingtung
- µù¥U®É¶¡
- 2011-9-2
- ³Ì«áµn¿ý
- 2024-7-5
|
¦^´_ 5# parker
¨Ó³o¨à´N¹ï°Õ¡I
¡u³Â»¶®a±Ú°Q½×°Ï¡v¦³¶W¯Åª©¥D»P³\¦h¼ö¦åªº¦Ñ®v¡A±`¤W¨Ó¾Ç²ß§a¡I |
|
|
|
|
|
|
- ©«¤l
- 8
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 9
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- office2007
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2013-10-6
- ³Ì«áµn¿ý
- 2013-11-14
|
¦^´_ 8# p212
§Ú§ä¨ì¤F,ì¨Ó§Ú¦h¥´ÓªÅ®æ,¥H«á§Ún±`¨Ó³o¬Ý¬Ýµ{¦¡½d¨Ò¼W¥[¥\¤O
ÁÂÁ¤F. |
|
|
|
|
|
|
- ©«¤l
- 8
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 9
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- office2007
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2013-10-6
- ³Ì«áµn¿ý
- 2013-11-14
|
¦^´_ 9# parker
¥t¤@Ó°ÝÃD¶À¦â¨º¤@Äæ(¦ì¸m)n¦p¦ó¤ñ¹ï¦]¸Ó¦³ÂIÃø«×¤£ª¾¦³°ª¤â¥i¸Ñµª¶Ü?? |
|
|
|
|
|
|