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

[µo°Ý] ¦p¦ó§PÂ_¬O§_ ¥þ§Î¦r?

¦^´_ 10# sunnyso


    ½Ð°Ý§A«ç¼Ë§ä¥X³o¨Ç¦r?
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 11# ML089

¼sªF¸Ü(¸f»y)¤f»y¦r
ss

TOP

¥»©«³Ì«á¥Ñ ML089 ©ó 2013-5-8 14:39 ½s¿è

§Ú»{¬° ASCII CODE 0~255 ¬°³æ¦r¤¸¡A¨ä¥L¥H¥~³£ºÙ¬°Âù¦r¤¸¤ñ¸û²³æ
³æ¦r¤¸¯S©Ê LEFT()»PLEFTB()¨ú­ÈÀ³¸Ó¬Û¦P
¥Î =LEFTB(A2)<>LEFT(A2) ¨Ó§PÂ_TRUE¬°Âù¦r¤¸¡AFALSE¬°³æ¦r¤¸


©ó¹ê°È¤W¹B¥Î½d¨Ò
R3 ="氹¥J¿DA1?¡H"
¦³4­Ó¥þ«¬¦r¡A ª`·N "氹" ¯S§O¦r¤¸ LENB()=1

­pºâ¥þ«¬¦r¤½¦¡
=SUMPRODUCT(--(MID(R3,ROW(1:9),1)<>LEFTB(MID(R3,ROW(1:9),1))))
=4
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 13# ML089

·PÁ¤j¤j, ³o¬O³Ì²¼ä ªº§PÂ_¡C
ss

TOP

½Ð±Ð«e½ú,µ{¦¡¦b°õ¦æ®É¹J¨ì¥þ§Î©Î¥b§Î¦r·|¥X²{¤£¦Pªºµ²ªG¶Ü?

TOP

°Ñ¦Ò¬Ý¬Ý¡G
=BIG5(A2)=A2

¤j¤Z¡e¯S®í¦r¡D¨u¥Î¦r¡D¦Û³y¦r¡f:
CODE¬°63¡ALENB¬°1¡A
©ñ¦bVBE®É¡AÅã¥Ü"?"
¸û±`¨£¦r¡A¦p¡G¡e堃¡f

TOP

¦^´_ 16# ­ã´£³¡ªL

BIG5 ¨ç¼Æ±N¥b§Î¦r¤¸Âà´«¦¨¥þ§Î (Âù¦ì¤¸²Õ) ¦r¤¸
A2¬°¤@­Ó¦r¤¸±¡ªp§PÂ_¬O§_¬° ¥þ¦r«¬
¥Î  =BIG5(A2)=A2 ¨Ó§PÂ_¤]¬O¦n¤èªk¡A¦ý¤´»Ýª`·NªÅ¦r¤¸ "" ¤ÎªÅ®æªº§PÂ_
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¤Sªøª¾ÃѤF
ÁÂÁÂ
ss

TOP

­pºâ¡e¥þ«¬¦r¡f¦r¤¸¼Æ¡G
¢Ï¢°¡G氹堃¥J¿DA12135¢ó?¡H
¢Ð¢°¡G=LEN(A1)+LENB(A1)-LENB(BIG5(A1))

¥H«e±q¨S¦Ò¼{¯S®í¤å¦r¡A¦¹ÃD¥X±o¦n¡I

TOP

¥»©«³Ì«á¥Ñ ML089 ©ó 2013-5-21 21:36 ½s¿è

¦^´_ 19# ­ã´£³¡ªL


    ÆgÆgÆg!
    ³oÀ³¸Ó¬O³Ð·s¤½¦¡

µù¸Ñ¤@¤U¡A¥H§K¤é«á­n§Ñ°O
B¡G¥þ«¬¦r¼Æ
S¡G¥b«¬¦r¼Æ
¢Ð¢°¡G=LEN(A1)+LENB(A1)-LENB(BIG5(A1))
¢Ð¢°¡G=B+S + B*2+S - (B*2 + S*2)
¢Ð¢°¡G=B + (B*2+S*2) - (B*2 + S*2)
¢Ð¢°¡G=B
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¡i¬O§_µo´§¤F¨}¯à¡H¡j¤H¶¡¹Ø©R¦]¬°µu¼È¡A¤~§óÅã±o¬Ã¶Q¡CÃø±o¨Ó¤@½ë¤H¶¡¡AÀ³°Ý¬O§_¬°¤H¶¡µo´§¤F¦Û¤vªº¨}¯à¡A¦Ó¤£­n¤@¨ý¨Dªø¹Ø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD