- ©«¤l
- 455
- ¥DÃD
- 8
- ºëµØ
- 1
- ¿n¤À
- 480
- ÂI¦W
- 0
- §@·~¨t²Î
- WINS home
- ³nÅ骩¥»
- OFFICE XP
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥Âí
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2015-1-22
|
MID($A5,FIND(",",$A5)+2,10)>>¨ú±o100PCS
FIND(MID($A5,FIND(",",$A5)+2,10),$B$1:$B$6)
>>¦b$B$1:$B$6¤¤¨ú±o¦³"100PCS"ªº©Ò¦b¦ì¸m,¥i¯à¬O{#VALUE!;#VALUE!;22;#VALUE!;#VALUE!;#VALUE!}
= ISNUMBER(FIND(MID($A5,FIND(",",$A5)+2,10),$B$1:$B$6))
={FALSE;FALSE;TRUE;FALSE;FALSE;FALSE}
IF(ISNUMBER(FIND(MID($A2,FIND(",",$A2)+2,10),$B$1:$B$6)),ROW($1:$6)
={FALSE;FALSE;3;FALSE;FALSE;FALSE} >>²Ä3Ó¦ì¸m¬°¯u
{="B"&MIN(IF(ISNUMBER(FIND(MID($A2,FIND(",",$A2)+2,10),$B$1:$B$6)),ROW($1:$6)))}
»PB²Õ¦X«á§Y¬°B3³oÓ¦ì¸m¦³"100PCS"³oÓ¬Û¦Pªº
¬°¤°»òn¥[MIN¬O¦]¬°¥i¯à¦³«Ü¦h¦ì¸m¦³¬Û¦Pªº"100PCS"¥u¨ú³Ì¥ý¥X²{ªº¦ì¸m |
|