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

¥u¨ú¼Æ¦r¤£¨ú¤å¦r

=LOOKUP(9999,--LEFT(MID(A1,MIN(FIND(ROW($A$1:$A$10)-1,A1&"0123456789")),99),ROW($1:$4)))   °}¦C¤½¦¡

TOP

=LOOKUP(9999,--LEFT(MID(A1,MIN(FIND(ROW($A$1:$A$10)-1,A1&"0123456789")),99),ROW($1:$4) ))
¬O¨úMID(A1,MIN(FIND(ROW($A$1:$A$10)-1,A1&"0123456789")),99)±o¨ìªº¦r¦ê¨ú¥ªºâ°_1¦ì,2¦ì,3¦ì,4¦ì¡A¦]§Aªº¼Æ¦r³Ì¦h¬°4¦ì¼Æ¡A¦p
lookup(9999,{1,12,123,1234})·|¨ú¨ì1234
¦pªG²Ä4¦ì¬O­^¤å¦r¥À,¥¦·|¨ú¨ì²Ä3¦ì

TOP

        ÀR«ä¦Û¦b : ¶¢¤HµL¼Ö½ì¡A¦£¤HµL¬O«D¡C
ªð¦^¦Cªí ¤W¤@¥DÃD