- ©«¤l
- 2831
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 2887
- ÂI¦W
- 0
- §@·~¨t²Î
- ¡e²¤¡f
- ³nÅ骩¥»
- ¡e²¤¡f
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¡e²¤¡f
- µù¥U®É¶¡
- 2013-5-13
- ³Ì«áµn¿ý
- 2024-11-4
|
¥»©«³Ì«á¥Ñ ã´£³¡ªL ©ó 2016-3-31 18:54 ½s¿è
¦^´_ 4# danny7014
=INDIRECT(LEFT(D$3,FIND("(",D$3&"(")-1))
¦]°Ñ·Ó©w¸q¦WºÙ¤å¦r¨ÃµL"(?¤H)"¡A©Ò¥H¶·¥h°£¡A
¨Ò¦p¡GÀu½è±Ð¾i§Ö¼Ö¦¨ªø(2¤H)¡@=LEFT(K$3,FIND("(",K$3&"(")-1))¡@Åܦ¨¡GÀu½è±Ð¾i§Ö¼Ö¦¨ªø
®æ¦¡¤Æ±ø¥ó¤½¦¡¡G
±ø¥ó¤@¡G¤H¼Æ¤wº¡¡D¶À¦â©³
=COUNT(0/(COUNT(D$3:D$999)+SUBSTITUTE(MID(D$3,FIND("(",D$3),9),"¤H",)=0))
=SUBSTITUTE(MID(D$3,FIND("(",D$3),9),"¤H",)¡@
¨ú¥X¬A¸¹¤Î¼Æ¦r (2¤H)¡A¦A±N"¤H"¨ú¥N²M°£¡AÅܦ¨ (2)¡A¨Ì¼ÆÈ©w¸q¡A¬A¸¹¤¤ªº¼Æ¦rµø¬°¡et¼Æ¡f¡A
»P¡@COUNT(D$3:D$999)¡@¬Û¥[¡@§Y¬°¤w¿é¤JӼƪº®tÈ¡A¡I |
|