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

[µo°Ý] ´£¨ú½s¸¹¤¤ªº¼Æ¦r&¼Æ¦r¸É¹s

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

TOP

¦^´_ 10# ML089

TOP

Test1.rar (6.73 KB) ¦^´_ 10# ML089

TOP

¦^´_ 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¸ß¤£¨ì
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 12# Qin

­Y½s½X¦³¤å¼Æ¦r®É(¤£«Øij)¡A¸Õ¸Õ¤U¦¡
f2 =INDEX(B:B,-LOOKUP(,-MATCH(IF({1,0},E2,--E2),A:A,)))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

Test_2.rar (7.81 KB) ¦^´_ 15# ML089


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

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

TOP

¦^´_ 16# Qin

¨S¦³¤Ç°t¦p¤U¡Aªø«×¤£¼Ë

10000000000001a
100000000000001a

150000000002160
15002160

15gb00000000435
15GB0435


20000000000336a
200000000000336a
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 17# ML089

·Q°Ýªº¬OAÄ檺½s½X¤å¼Æ¦rªøµu¤£¤@
EÄæ¬O­n¦p¦ó¦bDÄæ¿é¤J«á,¦p¦ó±N²Å¸¹"-"¦Û°Ê¸É¹s?

TOP

¥»©«³Ì«á¥Ñ ML089 ©ó 2017-3-22 23:09 ½s¿è

¦^´_ 18# Qin

F2 =VLOOKUP(SUBSTITUTE(D2,"-","*"),IF({1,0},A$2:A$99&"",B$2:B$99),2,)
°}¦C¤½¦¡¡A»Ý¥ÎCTRL+SHIFT+ENTER¤TÁä¿é¤J¤½¦¡


Test_2.rar (8.54 KB)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¥»©«³Ì«á¥Ñ Qin ©ó 2017-3-22 23:24 ½s¿è

¦^´_ 19# ML089

ÁÂÁÂ, ¥i¥H¤F

¦A´£°Ý

¦pªGDÄæ©|¥¼¿é¤J¥ô¦ó¤å¼Æ¦r

F2ªº°}¦C¤w¤U©Ô¤½¦¡¤£¬O"0", ¦Ó¬OªÅ¥Õªº.

³o¤S­n¦p¦ó¤U¤½¦¡?

TOP

        ÀR«ä¦Û¦b : ¡i¦æµ½­n¤Î®É¡j¦æµ½­n¤Î®É¡A¥\¼w­n«ùÄò¡C¦p¿N¶}¤ô¤@¯ë¡A¥¼¿N¶}¤§«e¤d¸U¤£­n°±º¶¤õ­Ô¡A§_«h­«¨Ó´N¤Ó¶O¨Æ¤F¡C
ªð¦^¦Cªí ¤W¤@¥DÃD