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

[µo°Ý] ¦h­ÓÀx¦s®æ¡]Äæ¡^­Èªº§PÂ_

[µo°Ý] ¦h­ÓÀx¦s®æ¡]Äæ¡^­Èªº§PÂ_

½Ð°Ý¦U¦ì«e½ú¡G
¦pÃD¡AAÄ檺A1~A7­È·|ÅÜ°Ê¡C
¦pªGA1ªº­È¬O³Ì¤j«h¦bB1¼g¤Jaaa
¦pªGA2ªº­È¬O³Ì¤j«h¦bB1¼g¤Jbbb
¦pªGA3ªº­È¬O³Ì¤j«h¦bB1¼g¤Jccc
¦pªGA4ªº­È¬O³Ì¤j«h¦bB1¼g¤Jddd
...
¦pªGA7ªº­È¬O³Ì¤j«h¦bB1¼g¤Jggg

¥»©«³Ì«á¥Ñ register313 ©ó 2012-3-5 13:48 ½s¿è

¦^´_ 1# sammay

¯uªº¥u¯à¶Çaaa~ggg
B1=REPT(CHAR(MATCH(MAX(A1:A7),A1:A7,0)+96),3)

B1=CHOOSE(MATCH(MAX(A1:A7),A1:A7,0),"a","b","c","d","e","f","g")

TOP

¥»©«³Ì«á¥Ñ sammay ©ó 2012-3-5 14:18 ½s¿è

¦^´_ 2# register313
¦hÁÂregister313¤j¤jªº¦^ÂСA§Ú¨Ï¥Î²Ä¤GºØ¤è¦¡CHOOSE(MATCH(MAX(A1:A7),A1:A7,0),"a","b","c","d","e","f","g")¡C

TOP

³o©Û¤£¿ù¥Î~ ¥H«e¨S¥Î¹Lrept¸òchoose
¥i¥H¾Ç°_¨Ó~ ¥H«á³Q»@¼g¦rªº®É­Ô®³¨Ó¥Î~
¾Ç²ß¤~¯à´£¤É¦Û¤v

TOP

        ÀR«ä¦Û¦b : ­ì½Ì§O¤H´N¬Oµ½«Ý¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD