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

[µo°Ý] [¤w¸Ñ¨M}³]©w®æ¦¡¤Æ±ø¥ó§ó§ïÃC¦â

[µo°Ý] [¤w¸Ñ¨M}³]©w®æ¦¡¤Æ±ø¥ó§ó§ïÃC¦â

¥»©«³Ì«á¥Ñ jiuhtsair ©ó 2011-10-26 19:06 ½s¿è

¦U¦ì¤j¤j¦n¡G test.zip (31.43 KB)

         §Ú¤U¸ü¤F¤@­Ó´Á¥æ©Òªº¿ï¾ÜÅv¸ê®Æ¡A¥i¬O¹J¨ì¤@­Ó°ÝÃD¡A·Q½Ð¦U¦ì¤j¤j¸Ñ´b¡CÁÂÁ¡I

         1.¦bK©ML¨âÄæ¡A§Ú¥Î®æ¦¡--->®æ¦¡¤Æ³]©w±ø¥ó...¥i¬OµLªkÅܧ󷡦s®æ¤ºªºÃC¦â(¨Ò¦p¤j©ó¹s¬°¬õ¦â¡A¤p©ó¹s¬°ºñ¦â..)

     2. ¤§«e¦³¤j¤j敎§Ú¥Î¨ä¥L¤è¦¡§ïÅÜÃC¦â..¦ý¦pªG§Ú±NKÄæ¥Îmid«ü¥O¨ú¥X¼Æ¦r(¦pQÄæ©Ò¥Ü)¡A«o¤´µMµLªk¥Î³]©w®æ¦¡¤Æ±ø¥ó§ó§ïÃC¦â¡A¦bUÄæ¡A¤p§Ì§Q¥ÎQÄæ*1ªº¤è¦¡¡A´N¥i¥H¨Ï¥Î³]©w®æ¦¡¤Æ±ø¥ó§ó§ïÃC¦â¡C

         ·Q½Ð±Ð¦U¦ì¤j¤j¡A¦pªG¤£¨Ï¥Î³o¤èªk¡A¬O§_¦³¨ä¥¦¤è¦¡¥i¥H§ïÅÜUÄ檺ÃC¦â(¥Î³]©w®æ¦¡¤Æ±ø¥ó)¡H

          ÁÂÁ¡I
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

¦^´_ 1# jiuhtsair
³o¼Ë¶Ü?
test (2).zip (26.79 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

qÄ椽¦¡§ï¬°=IF(LEN(K17)>1,--MID(K17,2,4),"")

TOP

¦^´_ 3# oobird
·PÁÂoobird©MHsieh¤j¤jªº¼ö¤ß¦^ÂСC
¤j·§¬O¤p§ÌÃ㤣¹F·N¡A¤p§Ì§Æ±æ±o¨ìªº¬O¥h°£º¦¶^ªº¤T¨¤§Î²Å¸¹©Ò±o¨ìªº¼Æ¦r¡A¦A¹ï¨ä°µ¬õ¦â©Îºñ¦âªº®æ¦¡³]©w¡C
¦ý¦]¬°Ã㤣¹F·N¡AÅý¤p§Ì¤S¦h¾Çªº¤@ºØ¤èªk¡C·PÁ¡I
ÁÂÁ¡I
oobird¤j¤jªº¤èªk¤p§Ì¸Õ«á¡A«z¡I´N¬O¤p§Ì©Ò¥ø¨Dªº¡I·PÁ¡I
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¦^´_ 2# Hsieh
·PÁÂHsieh¤j¤jªº¼ö¤ß¦^ÂСC
¤j·§¬O¤p§ÌÃ㤣¹F·N¡A¤p§Ì§Æ±æ±o¨ìªº¬O¥h°£º¦¶^ªº¤T¨¤§Î²Å¸¹©Ò±o¨ìªº¼Æ¦r¡A¦A¹ï¨ä°µ¬õ¦â©Îºñ¦âªº®æ¦¡³]©w¡C
¦ý¦]¬°Ã㤣¹F·N¡AÅý¤p§Ì¤S¦h¾Çªº¤@ºØ¤èªk¡C·PÁ¡I
ÁÂÁ¤j¤jªº¬Û§U¡I
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2011-10-26 19:17 ½s¿è

¤£¥[»²§UÄæ
§@¥ÎÀx¦s®æK16
ºñ¦â
=--SUBSTITUTE(SUBSTITUTE(K16,"¡¿",""),"¡¶","")<0
¬õ¦â
=--SUBSTITUTE(SUBSTITUTE(K16,"¡¿",""),"¡¶","")>0
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 6# Hsieh

·PÁ¤j¤j¼ö¤ß±Ð¾É¡CÁÂÁ¡I·P®¦¡I
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

        ÀR«ä¦Û¦b : ¡i¦æµ½­n¤Î®É¡j¦æµ½­n¤Î®É¡A¥\¼w­n«ùÄò¡C¦p¿N¶}¤ô¤@¯ë¡A¥¼¿N¶}¤§«e¤d¸U¤£­n°±º¶¤õ­Ô¡A§_«h­«¨Ó´N¤Ó¶O¨Æ¤F¡C
ªð¦^¦Cªí ¤W¤@¥DÃD