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

¦p¦ó³]©w²Õ¦X¤½¦¡°w¹ï¨ãµù°O¤§¶µ¥Ø¶i¦æ½s¸¹¡H

¦p¦ó³]©w²Õ¦X¤½¦¡°w¹ï¨ãµù°O¤§¶µ¥Ø¶i¦æ½s¸¹¡H

¥»©«³Ì«á¥Ñ p212 ©ó 2014-1-14 16:14 ½s¿è

°ÝÃD´y­z¡G
¦p¦ó³]©w²Õ¦X¤½¦¡°w¹ïAÄæµù°O¬°¡uv¡v©Î¡uz¡v¤§BÄæ¡u¶µ¥Ø¡v¶i¦æ½s¸¹¡HµL¡uv¡v©Î¡uz¡vµù°OªÌ¡ACÄæ½s¸¹¤º®e¥HªÅ¥ÕÅã¥Ü¡C
·Ð½Ð¦U¦ì«e½ú¥ý¶i½ç±Ð¡AÁÂÁ¡I

fig.JPG (67.27 KB)

fig.JPG

°ÝÃD¨Ò.zip (8.32 KB)

C2 =IF(OR(A2={"v","z"}),MAX(IF(B$1:B1=B2,C$1:C1))+1,"")
°}¦C¿é¤J
¤U©Ô
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 1# p212
C2¤@¯ë¤½¦¡¿é¤J
=IF(OR(A2={"v","z"}),SUMPRODUCT((($A$2:A2="v")+($A$2:A2="z"))*($B$2:B2=B2)),"")
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

C2¤@¯ë¤½¦¡¿é¤J
=IF(OR(A2={"v","z"}),SUMPRODUCT(($A$2:A2={"v","z"})*($B$2:B2=B2)),"")

TOP

ÁÂÁ±оÇ.­È±o¥[¥H«ä¦Ò¤@¤U.

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2014-1-16 10:33 ½s¿è

¦^´_ 3# Hsieh
«D±`·PÁÂHsieh¶W¯Åª©¥D»PML089ª©¥Dªº¼ö¤ß«ü¾É¡A¤µ¥t¦³¥»¥DÃD­l¥Í°ÝÃD(½Ð°Ñ¨£¤U¦Cºô§})¡A¥i§_¦A¦¸½ç±Ð¡HÁÂÁ¡I
http://forum.twbts.com/viewthread.php?tid=11112&extra=

TOP

        ÀR«ä¦Û¦b : ®É®É¦n¤ß´N¬O®É®É¦n¤é¡C
ªð¦^¦Cªí ¤W¤@¥DÃD