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

[µo°Ý] (¤w¸Ñ¨M)¦p¦ó¦P¤@°Ï¶ô¬Û¦P¸ê®Æ¼ÐÃC¦â

[µo°Ý] (¤w¸Ñ¨M)¦p¦ó¦P¤@°Ï¶ô¬Û¦P¸ê®Æ¼ÐÃC¦â

¥»©«³Ì«á¥Ñ freeffly ©ó 2012-2-22 17:19 ½s¿è

½Ð°Ý¦pªG¸ê®Æ±Æ§Ç¹L
¬Y¤@Äæ¦pªG¬O¦P¼Ë¸ê®Æ­n¼ÐÃC¦â¤À¶}¥i¥H¥Î±ø¥ó®æ¦¡°µ¨ì¶Ü?
ÁÙ¬O­n¥ÎVBA?







·s¼WMicrosoft Excel ¤u§@ªí.rar (1.76 KB)
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

®æ¦¡¤Æ±ø¥ó
=IF(MOD(SUM(1/(COUNTIF($B$2:$B2,$B$2:$B2))),2)<0.1,0,1) 111.gif

TOP

¦^´_ 2# ANGELA

¦P·~°È­û¶W¥X2ºØÃþ§O®É¡A©Î¤£¦P·~°È­û¦³µÛ¬Û¦PÃþ§O®Éª¬ªp¥i¯à¥X²{¤£¦P
¥i¯à¨Ì·~°È­û¬°½d³ò¾Þ§@¤ñ¸û¾A·í
·s¼WMicrosoft Excel ¤u§@ªí.rar (2.21 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# ANGELA


    ÁÂÁÂ
       µª®×¤ñ·Q¹³¤¤ªºÂ²³æ
       ¥i¬O­ì²z¬O¤°»ò?
    ÁÙ¨S·Q¥X¨Ó
      ©î¶}¬Ý³£¬ÝªºÀ´¦X°_¨ÓÁÙ­n·Q¤@¤U
     countif¸Ì­±ªº¤è¦¡§ÚÁÙ¨S¥Î¹L
   COUNTIF(range,criteria)
  ³oºØ¤è¦¡ºâ¬O¨âÃä³£¥Îrange¶Ü?
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

¦^´_ 3# Hsieh


    ÁÂÁ³á
       ¨Ò¤l¥i¯àÁ|±o¤£¤Ó¦n
       ¥D­n¬O·Q§PÂ_¬Y¤@Äæ
        ¤S¬Ý¨ì¨S¬Ý¹Lªº¦WºÙ¤è¦¡-Rng
        ¤S¾Ç¨ì¤@©Û
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

=SUM(1/COUNTIF($B$2:$B2,$B$2:$B2))
¤@¯ë¬O¥Î¨Ó¬d½d³ò¤ºªº°ß¤@¼Æ,¦X­p¦³´X­Ó.²Ä¤@­Ó$B$2¬Oµ´¹ï¤Þ¥Î,²Ä¤G­Ó$B2¬O¬Û¹ï¤Þ¥Î,·|¶¦¦Cªº¼W¥[¦Ó¼W¥[,¦bB2¨ìB4·|±o¨ì1,¦]¬°¥u¦³¤@ºØ,¦bB5 ·|±o¨ì2....¥H¦¹Ãþ±À
¥Î2¥h°£,¾l¼Æ¬O¤@ªº·|Åܦâ,0ªº¤£ÅÜ

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2011-10-8 18:14 ½s¿è

¦^´_ 2# ANGELA
=IF(MOD(SUM(1/(COUNTIF($B$2:$B2,$B$2:$B2))),2)<0.1,0,1)
¦b2003ª©¤]·|²£¥Í¥¿½T®ÄªG
¦ý¬O2010ª©¥»ªº©Ç²{¶H

­n§ï¦¨
=IF(MOD(INT(SUM(1/(COUNTIF($B$2:$B2,$B$2:$B2)))),2)<0.1,0,1)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

³oÀ³¸Ó¬O·L³n·sª©§ï¥¿¯BÂI¹Bºâ®t²§ªºÃö«Y§a,
excel¤£¦P¨ç¼Æªº¶i¦ìªº¤è¦¡¤]¤£²Î¤@,¦³®É¯u§ä¤£¥X¿ù¦b¨º¸Ì,
ÁÂÁª©¥Dªº«üÂI.

TOP

¦^´_ 6# ANGELA


    ¤j·§ª¾¹D·N«ä¤F
       ¤£¹L§Úªº°ÝÃD¤£¦Aµ´¹ï¸ò¬Û¹ï
       §Ú¥u¦³¬Ý¹LCOUNTIF($B$2:$B2,$B2)³oºØ¥Îªk
    COUNTIF($B$2:$B2,$B$2:$B2)³oºØªº§ÚÁÙ¬O²Ä¤@¦¸¬Ý¨ì
       ¯u¬O­n¦h°Ý¤~¯à¾Ç¨ì¦h¤@ÂIªF¦è
      ÁÂÁÂ
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

        ÀR«ä¦Û¦b : §ïÅܦۤv¬O¦Û±Ï¡A¼vÅT§O¤H¬O±Ï¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD