ªð¦^¦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

TOP

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}),">;<;=")&B1

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 : ¯u¥¿ªº·R¤ß¡A¬O·ÓÅU¦n¦Û¤vªº³oÁû¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD