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

[µo°Ý] ¹ï«D³æ¤@±ø¥óª¬ªp¤U¡A¦p¦ó¥H¡u¸ê®ÆÅçÃÒ¡v³]©w¦Û­q¤§¡u¤½¦¡¡v°õ¦æ´£¥Ü¥\¯à¡H

[µo°Ý] ¹ï«D³æ¤@±ø¥óª¬ªp¤U¡A¦p¦ó¥H¡u¸ê®ÆÅçÃÒ¡v³]©w¦Û­q¤§¡u¤½¦¡¡v°õ¦æ´£¥Ü¥\¯à¡H

¥»©«³Ì«á¥Ñ p212 ©ó 2013-10-18 11:01 ½s¿è

¹ï«D³æ¤@±ø¥ó¥B­­©w½d³òª¬ªp¤U¡A¦p¦ó¥H¡u¸ê®ÆÅçÃÒ¡v³]©w¦Û­q¤§¡u¤½¦¡¡v°õ¦æ´£¥Ü¥\¯à¡H
·Ð½Ð¦U¦ì¦Ñ®v½ç±Ð¡AÁÂÁ¡I
(http://forum.twbts.com/thread-10597-1-1.html°ÝÃD¦^ÅT)
¸ê®ÆÅçÃÒ_¦Û­q.JPG

¸ê®ÆÅçÃÒ_¦Û­q.zip (6.9 KB)

=COUNTIF($C3:$H3,C3)<=CHOOSE(CODE(C3)-64,3,2,9)

¶WªO¨Ï¥Î CHOOSE ¦³¯«¨Ó¤@µ§¤§®Ä
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2013-10-18 15:20 ½s¿è

¦^´_ 2# Hsieh
«D±`·PÁÂHsieh¶Wª©«ü¾É¡A¨ü¯q¨}¦h¡I
¥i¬O¹ï©ó¯Z§OC¨Ã¤£»Ý­n­­¨î¥X²{¦¸¼Æ¡A¿é¤J²Ä¤T­Ó¡uC¡v§Y¥¢®Ä¦Ó¥X²{´£¥Üµøµ¡¡A½Ð°Ý¸Ó¦p¦ó­×¥¿¡H
ÁÂÁ¡I
µù¡G¥»¤H¹Á¸Õ­×§ï¬õ¦r³¡¤À¡A¦pÀx¦s®æC3¤§¸ê®ÆÅçÃÒ±ø¥ó¡A¦ý¥¼¦¨¥\¡C
=SUMPRODUCT(($B$3:$B$7=$B3)*($C$3:$H$7=C3))<=CHOOSE(CODE(C3)-64,3,2,2)

TOP

¦^´_ 1# p212
°Ñ¦Ò¬Ý¬Ý
¸ê®ÆÅçÃÒ_¦Û­q.zip (8.81 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¤H¥Í¨S¦³©Ò¦³Åv¡A¥u¦³¥Í©Rªº¨Ï¥ÎÅv¡C
ªð¦^¦Cªí ¤W¤@¥DÃD