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

[µo°Ý] ½Ð°Ý¤½¦¡¦p¦ó¥ý­q¥ß³W«h,¦A§P©w ?

[µo°Ý] ½Ð°Ý¤½¦¡¦p¦ó¥ý­q¥ß³W«h,¦A§P©w ?

±¡ªp¦p¤U:
(³W«h) A>B>C>D>E
Àx¦s®æA1 = A  ;
Àx¦s®æB1 = B ¡C

§Ú·Q¦bÀx¦s®æC1¤º½s¼g¤½¦¡ : ¥ý­q¥ß³W«h,¦A§P©wA1©ÎB1¸û¤j¡C
½Ð°Ý¥i¥H¥Î­þ´Ú¤½¦¡ ? ÁÂÁÂ

http://blog.xuite.net/hcm19522/twblog/362380860
hcm19522 µoªí©ó 2015-12-4 10:40


ÁÂÁ¸ѵª

TOP

A1 = A
B1 = B
³W«h¡GA>B>C>D>E

¢Ñ¢°¡G
=A1&TEXT(MMULT(FIND(A1:B1,"ABCDE"),{-1;1}),">;
­ã´£³¡ªL µoªí©ó 2015-12-4 18:20



    ÁÂÁ¸ѵª

TOP

        ÀR«ä¦Û¦b : ¤Hªº¤ß¦a¬O¤@²¥¥Ð¡A¤g¦a¨S¦³¼½¤U¦nºØ¤l¡A¤]ªø¤£¥X¦nªºªG¹ê¡C -
ªð¦^¦Cªí ¤W¤@¥DÃD