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

[µo°Ý] ¦h±ø¥ó­pºâ¼Æ­È

¦^´_ 10# mark761222


§Ú¬O±N°}¦C©î¸Ñ¥X¨Óµ¹§A¬Ý¦b°}¦C·í¤¤ªºµ²ªG¡A
§Ú¬O±NE2¶ñ¤J¡uMATCH($A2,$A$2:$A$10,)=ROW($A2)-1)¡v©¹¤U©Ô¡A
§A¸Õ¸Õ¬Ý§a~

TOP

=COUNT(0/(MATCH(1&A2:A20,(B2:B20=1)*(C2:C20<14)&A2:A20,)=ROW(2:20)-1))

C2§ï¦¨¤j¤_14, µ²ªG¤´¬O2, ¦]¨ä¤UÁÙ¦³¤G­Ó¤p¤_14~~

MATCH(A2:A20,A2:A20,)=ROW(2:20)-1 ¤£¯à³æ¿W¨Ï¥Î, ·|¦³°ÝÃD!!
¥t¥~¤]­n¦Ò¼{AÄ榳ªÅ®æ, ¥ÎSUMPRODUCT·|¦³¿ù»~­È, ¥ÎCOUNT¸û¾A¥Î!

TOP

¦^´_ 12# ­ã´£³¡ªL


­ã¤j ±z¦n
   http://forum.twbts.com/thread-21018-1-1.html
  ¥i¥H½Ð±Ð¶Ü????·P®¦
yvonne

TOP

        ÀR«ä¦Û¦b : ¦Y­W¤F­W¡B­WºÉ¤Ü¨Ó¡A¨ÉºÖ¤FºÖ¡BºÖºÉ´d¨Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD