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

Â^¨ú¼Æ¦r

Â^¨ú¼Æ¦r

¦p¦ó¥uÂ^¨ú¼Æ¦r:

¬î¤M³½(AAA)(5g/Pc)
Åë³½(AAAA)(4.5g/Pc)
ÅÁ³½(AA)(3.5g/Pc)
³½(A)(0.55g/Pc)

µª®×:
5
4.5
3.5
0.55

¦^´_ 1# Qin
°}¦C¤½¦¡
=LOOKUP(9999,--MID(A1,MATCH(1,1/ISNUMBER(--MID(A1,ROW(INDIRECT("A1:A"&LEN(A1))),1)),0),ROW(INDIRECT("A1:A"&LEN(A1)))))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# Hsieh

¤£¦æ, µª®×¬O #N/A

TOP

¦^´_ 3# Qin


  Sorry, ¥i¥H¤F

TOP

¦^´_ 1# Qin
°²³]A1Àx¦s®æªº­È¬°  ¬î¤M³½(AAA)(5g/Pc)
B1Àx¦s®æ²Õ¦X¨ç¼Æ¬°  =MID(A1,SEARCH(")",A1)+2,SEARCH("g",A1)-(SEARCH(")",A1)+2))

»¡©ú1_SEARCH(")",A1)+2¥Øªº¦b§ä¥X²Ä¤G­Ó¥ª¬A©·¤§«á¼Æ¦r©Ò¦b¦ì¸m  ---§Y¬°MID¨ç¼Æªºstart_num
»¡©ú2_§ä¥X¡ug¡v®y¸¨ªº¦ì¸m¥Î  SEARCH("g",A1)
»¡©ú3_»¡©ú_2ªºµ²ªG´î¥h»¡©ú_1ªºµ²ªGSEARCH("g",A1)-(SEARCH(")",A1)+2) ---§Y¬°MID¨ç¼Æªºnum_chars

TOP

¦p¦ó¥uÂ^¨ú¼Æ¦r:

¬î¤M³½(AAA)(5g/Pc)
Åë³½(AAAA)(4.5g/Pc)
ÅÁ³½(AA)(3.5g/Pc)
³½(A)(0.55g/Pc)

µª ...
Qin µoªí©ó 2012-12-10 21:40


{=LOOKUP(9^9,--MID(A1,MIN(FIND(ROW($1:$10)-1,A1&1234567890)),ROW(INDIRECT("1:"&LEN(A1)))))}
300 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¸ê®ÆÂ\¦bA¦C , ¨Ï¥ÎMID+FIND§@ªk¦p¤U
=MID(A1,FIND(")(",A1,1)+2,FIND("g/Pc",A1,1)-FIND(")(",A1,1)-2)

TOP

¥»©«³Ì«á¥Ñ ML089 ©ó 2013-5-9 02:00 ½s¿è

LOOKUP«Ü¾A¥Î©ó°}¦C¤½¦¡¡A¦ý¦h¼hªºROW()¤]±À¤£°Ê

±N6¼Ó¤½¦¡¤U­×§ï¤@¤U¡A´N¤£¥Î°}¦C¤½¦¡¿é¤Jªk(CSE¿é¤J¤è¦¡)¿é¤J¤½¦¡
  1. =-LOOKUP(,-MID(A1,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A1&5/19)),ROW($1:$15)))
½Æ»s¥N½X
5/19 = 0.2631578947 ¼Æ¦r¥]§t 0~9³£¦³
±NROW(1:10)-1§ï¬°{0,1,2,3,4,5,6,7,8,9}´N¥i¥H§K¥Î CSE ¿é¤Jªk¡C
¥t¥~ROW(1:20)§ï¬°ROW(1:15)¡A¦]¬°³Ì¤j¦³®Ä¦ì¼Æ¥u¦³15¦ì¡A¸`¬Ù¤@ÂICPU®É¶¡¡C
±N9^9§R°£¡A¦]¬°¦¹¤½¦¡¥u¯à§ä¥¿¼Æ¦r¡A¥Î-MID(...)Åܦ¨­t¼Æ¦A¥Î0¨Ó§ä¡A³Ì«á¥Î-LOOKUP(...)Á٭쬰¥¿¼Æ¡C
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ºÉ¦h¤Ö¥»¥÷¡A´N±o¦h¤Ö¥»¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD