- ©«¤l
- 812
- ¥DÃD
- 7
- ºëµØ
- 0
- ¿n¤À
- 862
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¤¤
- µù¥U®É¶¡
- 2010-5-13
- ³Ì«áµn¿ý
- 2019-10-10
|
=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¦ì |
|