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

[µo°Ý] ¦³Ãö©óCountIfsªº°ÝÃD[¤w¸Ñ¨M]

[µo°Ý] ¦³Ãö©óCountIfsªº°ÝÃD[¤w¸Ñ¨M]

¥»©«³Ì«á¥Ñ asus103 ©ó 2011-1-13 08:48 ½s¿è

¦U¦ì¤j¤j±z¦n
§Ú·Q¦Aµ{¦¡¤¤ª½±µ²Î­p(¦pªþ¹Ï)
©Ò¦b¦C¤§¤W¡A¨Ã¦P®É¦³¬Û¦P¤@©Ê§O»P²Õ§Oªº¼Æ¶q
¥H¤U¬O§Ú©Ò¥Îªº
Application.CountIfs(.Range(.[E1], .Cells(i, "E")), .Cells(i, "E").Value, .Range(.[f1], .Cells(i, "F")), .Cells(i + 1, "F").Value)
(i=1¡A¨C¦¸¥[1)
¸Õ¹L´XºØ¤è¦¡³£¤£¦¨¥\¡A¥u¦n¦A³Â·Ð¦U¦ì¤F
capture_01122011_184728.jpg
ASUS

i = 2
   Do Until .Cells(i, 4) = ""
   .Cells(i, "G") = Application.CountIfs(.Range(.[E1], .Cells(i, "E")), .Cells(i, "E"), .Range(.[F1], .Cells(i, "F")), .Cells(i, "F"))
   i = i + 1
   Loop
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# Hsieh
Hsieh¤j¤j
¹ï¤£°_!!¬ðµM¦³¤@¨Ç¨Æ
§Ú©ú¤Ñ¦A­×µ{¦¡½X
ÁÙ¬O¥ýÁÂÁ±z
ASUS

TOP

¦^´_ 2# Hsieh
·PÁÂHsieh¤j¤j
°ÝÃD¸Ñ¨M¤F!!!
©w¦ì­ì¨Ó¤]¬O§Úªº¤@­ÓÃøÃD

¨ä¹ê³o¦¸§Ú³Ì¤jªº°ÝÃD¬O¾ã¬qµ{¦¡½XªºÅÞ¿èµ²ºc°ÝÃD
»P·Q­n´î¤ÖÅܼƨϥζq¡A¨Ïµ²ºc½ÆÂø¨ì¦Û¤vµLªk¾r¶¿
¥u¨£¨ä¤p¡A¥¼¨£¨ä¤jªºµ²ªG·íµM¬O¤@¹Î¶Ã
©¯¦n¦³±z¼ö¤ßªº¨ó§U
ÁÂÁÂ
ASUS

TOP

        ÀR«ä¦Û¦b : ¦³¦h¤Ö¤O¶q´N°µ¦h¤Ö¨Æ¡A¤£­n¤ß¦sµ¥«Ý¡Aµ¥«Ý¤~·|¸¨ªÅ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD