ML089

C2 =COUNTIF(D2:U2,"¤j*")/COUNTA(D2:U2)
C3 =COUNTIF(D3:U3,B3&"*")/COUNTA(D3:U3)

¿ïC2:C3¤U©Ô½Æ»s

ML089

¦^´_ 4# abc9gad2016

¿ïC2¡A©w¸q¦WºÙ Rng¡A°Ñ·Ó¨ì ¤½¦¡¦p¤U
=OFFSET(C2,,1,,MATCH(5,SUBTOTAL(3,OFFSET(C2,,1,,ROW($1:$31)))))


C2 =COUNTIF(Rng,"¤j*")/COUNTA(Rng)
C3 =COUNTIF(Rng,B3&"*")/COUNTA(Rng)

¿ïC2:C3¤U©Ô½Æ»s

ML089

¦^´_ 6# abc9gad2016

¦Û¦æ¬d¸ß¨ç¼Æ»¡©ú¡A ,, ªí¥Ü°Ñ¼Æ¥¼µ¹¡A¤@¯ë¤º©w­È¬°0

ML089

¦^´_ 7# abc9gad2016

»Ý¨Ï¥Î°}¦C¤½¦¡¿é¤J¤½¦¡
¤½¦¡¿é¤J®É¥ý«ö¦í CTRL+SHIFT ¤£©ñ¦A«ö ENTER ¤@»ô¿é¤J¤½¦¡

ML089

[quote]¦^´_  ML089

·PÁª©¤j¡A­è´ú¸Õ¤F¤@¤U
§Ú¦b¤£©w¸q¦WºÙªº±¡ªp¤U¡A¥Î¯x°}¿é¤JC2¬O¥i¥H®i²{¥Xµ²ªG¡A¦ýC3µ²ªG·|Åܬ°0
¥Î©w¸q¦WºÙªº¸Ü´N¥i¥H¥¿½T®i¥X
C2 =COUNTIF(Rng,"¤j*")/COUNTA(Rng)
C3 =COUNTIF(Rng,B3&"*")/COUNTA(Rng)

«Øij¥Î ©w¸q¦WºÙ ¤è¦¡³B²z


¥t¥~½Ð°Ý §Ú¦pªG·Q§âªñ¤­³õµ²ªG§ï¬°ªñ¤Q³õ¡A¦bMATCH«á­±ªº5§ï¬°10´N¥i¥H¤F¹ï¶Ü
=OFFSET(C2,,1,,MATCH(5,SUBTOTAL(3,OFFSET(C2,,1,,ROW($1:$31)))))

Yes