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

[µo°Ý] ¸ê®Æ¤À³Î

[µo°Ý] ¸ê®Æ¤À³Î

ªB¤Í­Ì¥­¦w
¤À³Î¤å¦r³q±`³£¨Ï¥Î ¸ê®Æ­åªR
¦ý¬O­Y­n±N¤U­±¼Æ¦r(8 , 9 , 10)»P¤å¦r¤À¶} , ³o¼Ë¥i¥H«ç»ò°µ

8ªá½¬¿¤¨ô·Ë¶m¨ô²M§ø¨ô·Ë9¾F17¸¹
9ªá½¬¿¤¨ô·Ë¶m¨ô·Ë§ø¨ô¼Ö17¾F62¸¹
10ªá½¬¿¤¨ô·Ë¶m¨ô²M§ø²M¤ô17¸¹
µL¤îºÉªº§V¤O¤W¶i

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

TOP

¨S¦³¢¯¶}ÀYªº¸Ü¡G
=-LOOKUP(1,-LEFT(A1,ROW($1:$9)))

§_«h¡G
=MID(-LOOKUP(1,-LEFT(1&A1,ROW($1:$9))),2,9)

TOP

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

ÁÂÁª©¥Dªº¸Ñµª
¤j¤j·P¿E
µL¤îºÉªº§V¤O¤W¶i

TOP

        ÀR«ä¦Û¦b : ¡i°µ¤Hªº¶}©l¡j¨C¤@¤Ñ³£¬O¬G¤Hªº¶}©l¡A¨C¤@­Ó®É¨è³£¬O¦Û¤vªºÄµ±§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD