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

p212

°ÝÃ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

ML089

C2 =IF(OR(A2={"v","z"}),MAX(IF(B$1:B1=B2,C$1:C1))+1,"")
°}¦C¿é¤J
¤U©Ô

Hsieh

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

samwang

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

takya

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

p212

¦^´_ 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=