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

[µo°Ý] Excel½s¿è°ÝÃD

[µo°Ý] Excel½s¿è°ÝÃD

¹w¦bC1®æ¤º¿é¤J¬P´Á¤@«á C2¦ÜC31®æ¤º¦Û°ÊÅã¥Ü¬P´Á¤G¦Ü¤é
¤£¯à¥Î·Æ¹«©ì¦²¤è¦¡³B²z
¥u¯à¦bC1®æ¤º¿é¤J®æ¦¡¤Æ±ø¥ó©Î¨ç¼Æ ©Î¨ä¥L......
·Ð½Ð°ª¤â«ü¾É ·PÁÂ~~~>"<

¹w¦bC1®æ¤º¿é¤J¬P´Á¤@«á C2¦ÜC31®æ¤º¦Û°ÊÅã¥Ü¬P´Á¤G¦Ü¤é
¤£¯à¥Î·Æ¹«©ì¦²¤è¦¡³B²z
¥u¯à¦bC1®æ¤º¿é¤J®æ¦¡ ...
roderick25 µoªí©ó 2016-11-10 17:18


©êºp§ó¥¿:"¥u¯à¦bC1®æ¤º¿é¤J®æ¦¡¤Æ±ø¥ó©Î¨ç¼Æ"
§ó¥¿¬°:¥u­n±ø¥óº¡¨¬¬°¦bC1¿é¤J¬P´Á C2¦ÜC31¦Û°ÊÅã¥Ü³Ñ¾l¬P´Á§Y¥i

TOP

="¬P´Á"&MID("¤@¤G¤T¥|¤­¤»¤é",MOD(FIND(RIGHT(C$1),"¤@¤G¤T¥|¤­¤»¤é")+ROW(A1)-1,7)+1,1)

TOP

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

TOP

C2¿é¤J¤½¦¡¦p¤U
=MID("¤@¤G¤T¥|¤­¤»¤é",MOD(FIND(C1,"¤@¤G¤T¥|¤­¤»¤é"),7)+1,1)
¤½¦¡©¹¤U½Æ»s
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¥H«e³£¥¼¾Ç¹L
¥¼·Q¨ì³o¤]¦³¤½¦¡
¼F®`

TOP

¥i¥H¥Î  ¦sÀx®æ®æ¦¡  ³B²z

¨Ò¦p A1 ¿é¤J 2016/11/1
¥kÁä - Àx¦s®æ®æ¦¡ - ¼Æ­È - ¦Û­q ³]¬° [$-804] aaa

A1¤U©Ô +1
©Î
A2 = A1 + 1 ¤U©Ô½Æ»s¤½¦¡»P®æ¦¡



¦^´_ 6# alicechan11
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¹w¦bC1®æ¤º¿é¤J¬P´Á¤@«á C2¦ÜC31®æ¤º¦Û°ÊÅã¥Ü¬P´Á¤G¦Ü¤é
¤£¯à¥Î·Æ¹«©ì¦²¤è¦¡³B²z
¥u¯à¦bC1®æ¤º¿é¤J®æ¦¡ ...
roderick25 µoªí©ó 2016-11-10 17:18


°ÝÃD¤w¸Ñ¨M    ÁÂÁª©¤W°ª¤â­Ì«ü¾É:'(

TOP

=CHOOSE(MOD(FIND(C1,"¤é¤@¤G¤T¥|¤­¤»"),7)+1,"¤é","¤@","¤G","¤T","¥|","¤­","¤»")

TOP

¬Ý¨ì¤@­Óºâ²³æªº§@ªk¡A¦ý¬O¨S·Q¨ì¦³³o»ò¦hªº¸Ñ¨M¤è¦¡¡A°ª¤â¦p¶³

TOP

        ÀR«ä¦Û¦b : §Ú­Ì³Ì¤jªº¼Ä¤H¤£¬O§O¤H¡D¥i¯à¬O¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD