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

[µo°Ý] ½Ð°Ý°ª¤â¤j¤j­Ì~³o¼Ëªº¨ç¼Æ¤½¦¡¸Ó¦p¦ó¼g©O?

[µo°Ý] ½Ð°Ý°ª¤â¤j¤j­Ì~³o¼Ëªº¨ç¼Æ¤½¦¡¸Ó¦p¦ó¼g©O?

½Ð°Ý°ª¤â¤j¤j­Ì~³o¼Ëªº¨ç¼Æ¤½¦¡¸Ó¦p¦ó¼g©O?
«ÜÃø­C~¯u¤£ª¾¸Ó¦p¦ó¼g¤~¦n

¬õ¦â®Ø®Ø¬O§Ú·Q­nªºµ²ªG

»¡©ú¡G

AÄæ¦ì¡G¹s¥ó½s¸¹¼Æ¶q¨C­Ó¤ë·|ÅÜ°Ê

EÄæ¦ì¡G¬O®Ú¾ÚAÄæ¦ì¬Û¦P½s¸¹¦Ó¨Óªº¼Æ¦r
         ¦pªG¬O³æ¿Wªº½s¸¹¥u¦³¤@­Ó´N¤£Åã¥Ü

FÄæ¦ì¡G¬O®Ú¾ÚAÄæ¦ì¬Û¦P½s¸¹ªº®t»ù¥[Á`¦Ó¨Ó
         ¦pªG¬O³æ¿Wªº½s¸¹®t»ù´N¤£Åã¥Ü


countif sum.rar (2.44 KB)

¦^´_ 1# alltest

E3=IF(($A3<>$A4)*(COUNTIF($A$3:$A$17,$A3)>1),COUNTIF($A$3:$A$17,$A3),"")
F3=IF(($A3<>$A4)*(COUNTIF($A$3:$A$17,$A3)>1),SUMIF($A$3:$A$17,$A3,$D$3:$D$17),"")
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥»©«³Ì«á¥Ñ alltest ©ó 2013-1-22 22:46 ½s¿è

«D±`·PÁÂ~ Hsieh ¶W¯Åª©¥D ¤j¤jªº¸Ñµª
¤w¸g°õ¦æ¦¨¥\¤F
¤£¹L©O,¤½¦¡§ÚÁÙ¶·­nªá¨Ç®É¶¡¤F¸Ñ®ø¤Æ¤@¤U~«D±`·P®¦^^

TOP

        ÀR«ä¦Û¦b : ¤H¨ÆªºÁ}Ãø»PµZ¿i¡A´N¬O¤@ºØ¦ÒÅç¡C
ªð¦^¦Cªí ¤W¤@¥DÃD