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

[µo°Ý] ½Òµ{¤H¼Æ­­¨î³]©w¤èªk

[µo°Ý] ½Òµ{¤H¼Æ­­¨î³]©w¤èªk

¦U¦ì¤j¤j¡G
¦]¤u§@³æ¦ìªñ´ÁÁ|¿ì¤@¨Ç½Òµ{¡A¦Ó¨C­Ó½Òµ{¦³¤H¼Æ­­¨î¡A¨º¦bµn°O®É¬O§_¥i¥H³]©w¶W¹L¤H¼ÆµLªk¦Aµn°O©Î¬O´£¿ôµn°O¤H¤H¼Æ¤w¸gº¡¤F©O¡H
ªþ¤W¹Ï¤ù¤ÎÀɮסAÀµ¨D¦U¦ì¤j¤jªºÀ°¦£¤F¡C

javascript:;

javascript:;

¹Ï¤ù.jpg (209.47 KB)

µe­±

¹Ï¤ù.jpg

105¦~«×¦b¾½Òµ{Á`ªí.rar (62.76 KB)

http://blog.xuite.net/hcm19522/twblog/397680423
°Ñ¦Ò

TOP

¥»©«³Ì«á¥Ñ ­ã´£³¡ªL ©ó 2016-3-31 18:44 ½s¿è

¤U©Ô²M³æ¡A¸ê®ÆÅçÃÒ¤½¦¡§ï¬°¡G
¢Ò¢³¡G=INDIRECT(LEFT(D$3,FIND("(",D$3&"(")-1))¡@®M¥Î¦Ü¨ä¥¦®æ

®æ¦¡¤Æ±ø¥ó¤½¦¡¡G
±ø¥ó¤@¡G¤H¼Æ¤wº¡¡D¶À¦â©³
=COUNT(0/(COUNT(D$3:D$999)+SUBSTITUTE(MID(D$3,FIND("(",D$3),9),"¤H",)=0))
±ø¥ó¤G¡G¤H¼Æ¶W¹L
=COUNT(0/(COUNT(D$3:D$999)+SUBSTITUTE(MID(D$3,FIND("(",D$3),9),"¤H",)>0))

¤H¼Æ­­¨î¤å¦r¡A¥²¶·©T©w¡A¨Ò¦p¡GÀu½è±Ð¾i§Ö¼Ö¦¨ªø(2¤H)¡@

°Ñ¦ÒÀÉ¡G
http://www.funp.net/328583

TOP

ÁÂÁ¨â¦ì¤j¤j´£¨Ñªº¸ê°T¡A³£«Ü¹ê¥Î¡A«D±`·PÁ¨â¦ì¡C
¥t¥~¡A·Q­n½Ð±Ð­ã´£³¡ªL¤j¤j¡A¦]¬°±zªº¤½¦¡§Ú¦³¨Ç¤£©ú¥Õ¡A¥i§_´N¦U­Ó¨ç¼Æµy¬°¸ò§Ú¸Ñ»¡¤@¤U¡A·PÁ±z

TOP

¥»©«³Ì«á¥Ñ ­ã´£³¡ª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µø¬°¡e­t¼Æ¡f¡A
»P¡@COUNT(D$3:D$999)¡@¬Û¥[¡@§Y¬°¤w¿é¤J­Ó¼Æªº®t­È¡A¡I

TOP

¦^´_ 5# ­ã´£³¡ªL

·PÁ¤j¤jªº»¡©ú¡A«D±`ªºÁÂÁ±z!!!

TOP

        ÀR«ä¦Û¦b : ª¾ÃÑ­n¥Î¤ßÅé·|¡A¤~¯àÅܦ¨¦Û¤vªº´¼¼z¡C
ªð¦^¦Cªí ¤W¤@¥DÃD