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

§Q¥ÎExcel¤ñ¹ï¦hµ§¦³¤À¹j²Å¸¹¸ê®Æªº¬Û¦P³B

§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...............
.
.
.
.

¥»©«³Ì«á¥Ñ p212 ©ó 2013-10-7 08:36 ½s¿è

¦^´_ 1# parker
¤£¤Ó©úÁA±zªº°ÝÃD¡A¥i¥H´£¨Ñ¤@¤U±z­nªº½d¨Òµª®×¤@°_¬ã¨s¡HÁÂÁ¡I(¦pªG¯à¶KExcel¤º®eµe­±Äæ¦ì¤À¥¬»¡©ú§ó¦n)

TOP

¥»©«³Ì«á¥Ñ parker ©ó 2013-10-7 20:26 ½s¿è

¦^´_ 2# p212
½ÐÀ°¦£¬ÝªþÀɪº¤å¥ó,³o¬O§Ú­Ì­n«ØÀɪºBOMªí§Ú¥u§T¨ú¤Ö³¡¥÷¡A¶À¦âÄæ¦ì(¦ì¸m)¬O§Ú·Q­n¦Û°Ê¤ñ¹ï¬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)

TOP

¥»©«³Ì«á¥Ñ 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)¡G­pºâD2Àx¦s®æ­ì¦³¦r¼Æ
2¡BSUBSTITUTE(D2,",","")¡G§R°£D2Àx¦s®æ¤¤ªº³r¸¹¨Ï¦r¦ê¬°³sÄò¤£¤¤Â_
3¡BLEN(SUBSTITUTE(D2,",",""))¡G­pºâ§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

TOP

¦^´_ 4# p212


    ·PÁ¤F½Ð°Ý¦³¨º¨Ç®Ñ¥»©Îºô¯¸¦³¦b±Ðexcelªº³o¨Ç¤½¦¡¼gªk???§Ú·Q­n¦n¦n¾Ç²ß¬ã¨s¤@¤U.

TOP

¦^´_ 4# p212


    P212¤j¼w;
                   §Ú­è­èkey¤J¤½¦¡¦bC2Äæ¦ì¸ÕÅçµoı¤£¦æ,ÅܪťյL¥ô¦ó¼Æ¦r???¬O§Ú¤½¦¡key¿ùÄæ¦ì¤F¶Ü??


ÁÂÁÂ

TOP

¥»©«³Ì«á¥Ñ 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

TOP

¦^´_ 5# parker
¨Ó³o¨à´N¹ï°Õ¡I
¡u³Â»¶®a±Ú°Q½×°Ï¡v¦³¶W¯Åª©¥D»P³\¦h¼ö¦åªº¦Ñ®v¡A±`¤W¨Ó¾Ç²ß§a¡I

TOP

¦^´_ 8# p212


    §Ú§ä¨ì¤F,­ì¨Ó§Ú¦h¥´­ÓªÅ®æ,¥H«á§Ú­n±`¨Ó³o¬Ý¬Ýµ{¦¡½d¨Ò¼W¥[¥\¤O

ÁÂÁ¤F.

TOP

¦^´_ 9# parker


    ¥t¤@­Ó°ÝÃD¶À¦â¨º¤@Äæ(¦ì¸m)­n¦p¦ó¤ñ¹ï¦]¸Ó¦³ÂIÃø«×¤£ª¾¦³°ª¤â¥i¸Ñµª¶Ü??

TOP

        ÀR«ä¦Û¦b : ¤f»¡¤@¥y¦n¸Ü¡A¦p¤f¥X½¬ªá¡F¤f»¡¤@¥yÃa¸Ü¦p¤f¦R¬r³D¡C
ªð¦^¦Cªí ¤W¤@¥DÃD