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

[µo°Ý] ®æ¦¡¤Æ±ø¥óÃC¦â­p¼Æ°ÝÃD

[µo°Ý] ®æ¦¡¤Æ±ø¥óÃC¦â­p¼Æ°ÝÃD

¤j¤j­Ì:
§Ú¦³¤@­ÓÀÉ®×~~¦]¬°»Ý¨DÃö«Y~¸ê®Æªºµ§¼Æ«Ü¦h
§Ú¤S¥²¶·¨Ì¤é´Á±ø¥ó¿z¿ï¥X¦U¤uµ{®v¨Ï§_¦³·Ç®Éú¥æ¦U¶µ¤å¥óªº¤@¥÷²Î­p³øªí
©Ò¥H§Ú¦bùØÀY¥Î¤F®æ¦¡¤Æ±ø¥ó¥HÃC¦â°Ï¹j¦U¤uµ{®vªº¤@­Óú¥æª¬ªp
¦ý¬O¥Ø«e¹J¨ì¤F¤@­Ó°ÝÃD
§Ú¤£ª¾¹D¨Ì·Ó¤uµ{®v¦W¦r»P©ÒÄݪºÃC¦â¥h°µ­p¼Æ....¦Ó¥B®æ¦¡¤Æ±ø¥ó¬O¤£¬O¨S¦³¹ê½èªºÃC¦â¦s¦b©O???
©Ò¥H·Q½Ð±Ð¤j¤j­Ì³o³¡¤À¤£ª¾¥i¥H«ç»ò¥Î©O???¦]¬°§Ú¤£·|¼gVBA.....ÁÙ¬O¦³¨ä¥L¤è¦¡¥i¸Ñ¨M©O???

¦b¦¹¥ýÁÂÁ¦U¦ì¤j¤jªºÀ°¦£¤F¤F......
111.png
¥¼©R¦W.png

¶i«×ªí- ³øªí.rar (183.43 KB)

¦^´_ 1# dodo234

¥i°Ñ¦Ò¤U¤è³o¨â­Óºô¯¸
http://isvincent.pixnet.net/blog/post/34018213-excel-%E5%8F%96%E5%BE%97%E5%84%B2%E5%AD%98%E6%A0%BC%E7%9A%84%E8%89%B2%E5%BD%A9
http://forum.twbts.com/thread-14248-1-1.html

¥D­n§@ªk¬O¨Ï¥ÎGET.CELL(63,Àx¦s®æ)¨Ó¨ú±oÀx¦s®æÃC¦âªº¥N¸¹(¬õ¦â¬O3)

¦A¥ÎCOUNTIF¨Ó­pºâ3ªº­Ó¼Æ

´N¥i¥Hºâ¥X¬õ¦âÀx¦s®æªº­Ó¼Æ¤F
¥Î¥\¨ì¥@¬É¥½¤é¨º¤@¤Ñ¡ã¡ã¡ã

TOP

        ÀR«ä¦Û¦b : §Ú­Ì³Ì¤jªº¼Ä¤H¤£¬O§O¤H¡D¥i¯à¬O¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD