[µo°Ý] «ü©w¦r¤¸°ÝÃD½Ð±Ð

rouber590324

DEAR  SIR
1. RANGE("I10")= S(H)(ù)(280.3)
2.RANGE("A10") ¨Ï¥Î¨ç¼Æ = MID(I10,SEARCH("(",I10)+1,SEARCH(")",I10)-SEARCH("(",I10)-1)
  2.1 µª®×±o  H
3.½Ð±Ð­Y§Ú·Q±o¨ì 280.3 ´N¬O§ï¥Ñ¦r¤¸³Ì«á¤è¶}©l§ä   (  »P  ) ½Ð°Ý¨ç¼Æ¦p¦ó®Ñ¼g
    ÁÙ¬O­n¥Î VBA
4.·Ð¤£§[½ç±Ð.  THANKS*10000

red

½Ð°ÝJBY 2­Ó°ÝÃD
=LOOKUP(9^9,--RIGHT(SUBSTITUTE(I10,")",),ROW($19)))
1. 9^9 ¬O¦X·N
2. ROW¡]¢C1¡G¢C9¡^¬O¦ó·N
¤£¬O«ÜÀ´
¬O§_¥i¥H¦b³Â·Ð »¡©ú¤@¤U

rouber590324

DEAR JBY  ¤j¤j
100%²Å¦X»Ý¨D·PÁ±z  THANKS*10000

JBY

I10: S(H)(ù)(H)(-280.3)

=LOOKUP(9^9,--RIGHT(SUBSTITUTE(I10,")",),ROW($1:$9)))

rouber590324

DEAR  ALL¤j¤j
½Ð±Ð¬°¦ó¨Ï¥Î¹Ï¤@¤½¦¡ - ¬A¸¹¤º¤§­È = -280.3  ¦ý ¥N¥X¬°  280.3
- ¤£¨£°Õ  : À³¥N¥X  -280.3  ·Ð¤£§[½ç±Ð.  THANKS*10000
S(H)(ù)(H)(-280.3)

¹Ï¤@
=-LOOKUP(,-RIGHT(SUBSTITUTE(I10,")",),ROW($19)))

=-LOOKUP(,-MID(I10,MIN(FIND({0;1;2;3;4;5;6;7;8;9},I10&5^19)),ROW($130)))

rouber590324

DAER   ML089  SIR
100%²Å¦X»Ý¨D. ¨ü±Ð©Ô THANKS*10000

ML089

¦^´_ 1# rouber590324


=-LOOKUP(,-RIGHT(SUBSTITUTE(I10,")",),ROW($1:$9)))

rouber590324

DAER   JBY  SIR
¤Ó±j°Õ. §ÚÁÙ¨S¬Ý¹L¦p¦¹¥Îªk.100%²Å¦X»Ý¨D. ¨ü±Ð©Ô THANKS*10000

JBY

DAER   JBY  SIR
I10Åܦp¤U´NµLªk°Õ.¤´·PÁ±z¤§¤è¦¡.¨ü±Ð­ù  THANKS*10000
S(H)(ù)(H)(280.3)
rouber590324 µoªí©ó 2015-5-12 16:31

=-LOOKUP(,-MID(I10,MIN(FIND({0;1;2;3;4;5;6;7;8;9},I10&5^19)),ROW($1:$30)))

rouber590324

DAER   JBY  SIR
I10Åܦp¤U´NµLªk°Õ.¤´·PÁ±z¤§¤è¦¡.¨ü±Ð­ù  THANKS*10000
S(H)(ù)(H)(280.3)