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

VBAªºWorksheetFunction°ÝÃD

VBAªºWorksheetFunction°ÝÃD

§Ú¥Ø«e¦³´X¥÷¸ê®Æ­n¾ã²z
¨ä¤¤¸I¨ì¤@­Ó°ÝÃD
¬O­n­pºâ¡A¯S©w½d³ò¤º¡A¤£­«½Æ¸ê®Æªº¼Æ¶q
­Y¥Îexcel¤½¦¡¡A¥i¥H¼g¦¨
=SUMPRODUCT(1/(COUNTIF(C2:C1881,C2:C1881)))

¦ý¬O¦]¬°§Ú»Ý­nª½±µ¼g¦bVBAµ{¦¡¤º
·Q»¡§ï¼g¦¨
= WorksheetFunction.SumProduct(1 / (WorksheetFunction.CountIf(Range("C2:C1881"), Range("C2:C1881"))))
¦ý¬O°õ¦æªº®É­Ô³£·|¥X¿ù
·Q½Ð°Ýª©¤W°ª¤âª¾¹D­n«ç»ò¸Ñ¨M¶Ü???
thank you!!

        ÀR«ä¦Û¦b : ¤f»¡¦n¸Ü¡B¤ß·Q¦n·N¡B¨­¦æ¦n¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD