Qin

Test_2.rar (7.81 KB)

¤U¸ü¦¸¼Æ: 3

2017-3-22 20:31

¦^´_ 15# ML089


  ÁÂÁÂ, µª®×Åã¥Ü¥X¨Ó¤F

  ¦ý§Ú¤S¦³¤F·sªº´£°Ý...

ML089

¦^´_ 12# Qin

­Y½s½X¦³¤å¼Æ¦r®É(¤£«Øij)¡A¸Õ¸Õ¤U¦¡
f2 =INDEX(B:B,-LOOKUP(,-MATCH(IF({1,0},E2,--E2),A:A,)))

ML089

¦^´_ 12# Qin

=VLOOKUP(E2,A2:B6,2,0)
­n§ï¬°
=VLOOKUP(E2,A$2:B$9,2,0)
½d³ò­n¥Î$Âê¦í¡A¤£µM¤U©Ô®É½d³ò¦^¶]±¼
½d³ò¤j¤p¤]­n­×§ï


E3¬O¤å¦r¡AA3¬O¼Æ¦r
E6¬O¤å¦r¡AA4¬O¼Æ¦r
©Ò¥H¥ÎVLOOKUP¬d¸ß¤£¨ì

Qin

Test1.rar (6.73 KB)

¤U¸ü¦¸¼Æ: 4

2017-3-21 23:47

¦^´_ 10# ML089

Qin

¤U¸ü (41.69 KB)

2017-3-21 23:31

¦^´_ 10# ML089

­ã´£³¡ªL

=SUBSTITUTE(A1,"-",REPT(0,16-LEN(A1)))

ML089

¦^´_ 8# Qin

¦^ÂÐ 8¼Ó·sÃD¥Ø
±N "-" ³B´¡¤J0¡Aªø«×§ï¬°15¦ì

=REPLACE(A1,FIND("-",A1),1,REPT(0,16-LEN(A1)))

ML089

A1 =SUM(MID(A1,{4,10},{5,3})*{1000,1})

Qin

¦p¦ó±N "-" ²Å¸¹§ï¦¨"0",

¨C²Õ½s¸¹¦@15­Ó¦r¤¸

¦p¤U:

1-1234
11-532
8-1
4-32167
M-1000

Åܦ¨
100000000001234
110000000000532
800000000000001
400000000032167
M00000000001000

yc1031

¦^´_ 6# hugh0620


½s½Xªº³Ì«á¦³¥i¯à¬O2½X©Î3½X
±z«Øijªº¨ç¼Æ, §Ú¦³¾ÇµÛ­×§ï¤@ÂIÂI¦¨ =MID(A2,4,5)&IF(VALUE(RIGHT(A2,3))<0,"0"&RIGHT(A2,2),RIGHT(A2,3))
¤]¬O¥i¦æªº! «D±`ÁÂÁ±z!