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

[µo°Ý] ¦p¦ó¨ú¯S©w¦r ­pºâ¾÷²v

[µo°Ý] ¦p¦ó¨ú¯S©w¦r ­pºâ¾÷²v

2016©uÁÉ.rar (12.02 KB)

½Ð°Ýª©¤W«e½ú¡A¦pªþ¥ó
C2Äæ¾÷²v:­n¦p¦ó­pºâ"¤j"ªº¾÷²v EX:Á`¦@7³õ¦³3³õ¤j¡A¾÷²v¬°3/7=43%
C3Äæ¾÷²v:­n¦p¦ó­pºâ¥k¦C¦³­þ¨ÇÄÝ©óB3Äæ¦ì¼Æ¦r EX:Á`¦@7­Ó¦³3­Óªi¤h¹y¡A¾÷²v¬°3/7=43%

¦]¬°¤£ª¾¹D­n¦p¦ó¥u¦ê¬Y¨Ç¦r¡A¦Ó¤£¬O¾ã­ÓÀx¦s®æ¡A­W«ä¤F¦n´X¤Ñ ÁÙ¬O·Q¤£µÛ¤èªk
ÁٽЦ³®É¶¡ªº«e½ú¥i¥H´£¨Ñ¤½¦¡ ·PÁÂ

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

¿ïC2:C3¤U©Ô½Æ»s
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 2# ML089

·PÁª©¥D¡A¤S¾Ç²ß¨ì¤@ºØ·sªº¨Ï¥Î¤è¦¡ ÁÂÁÂ

TOP

¦^´_ 2# ML089

½Ð°Ýª©¥D¡A­Y¬O§Ú¥u·Q¬Ýªñ¤­³õªº¾÷²v¡A½Ð°Ý­n¦p¦ó½Õ¾ã¤½¦¡

¦]¬°¦U¶¤¥´§¹¤­³õªº¤é´Á¨Ã¤£¤@©w¡A¤£¯àª½±µ©T©w¦b¬YÄæ¦ì
ÁÂÁÂ

TOP

¦^´_ 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
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 5# ML089

·PÁª©¥D¡A§Ú¦A¨Ó¸Õ¸Õ
¥t¥~·Q¥ý½Ð°Ý¦p¤U¤½¦¡",,"¨â­Ó³rÂIªº·N«ä¬O¤°»ò¡A²Ä¤@¦¸¬Ý¨ì ÁÂÁÂ
=OFFSET(C2,,1,,MATCH(5,SUBTOTAL(3,OFFSET(C2,,1,,ROW($1:$31)))))

TOP

¦^´_ 5# ML089

¥t¥~½Ð°Ýª©¥D¡A­Y§Ú¥ý¤£¥Î©w¸q¦WºÙªº¤è¦¡¡A±NRngªº¤º®e®M¨ìC2,C3¤º¡A¦n¹³¶]¤£¥Xµ²ªG ½Ð°Ý¬O¬°¤°»ò©O

TOP

¦^´_ 6# abc9gad2016

¦Û¦æ¬d¸ß¨ç¼Æ»¡©ú¡A ,, ªí¥Ü°Ñ¼Æ¥¼µ¹¡A¤@¯ë¤º©w­È¬°0
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 7# abc9gad2016

»Ý¨Ï¥Î°}¦C¤½¦¡¿é¤J¤½¦¡
¤½¦¡¿é¤J®É¥ý«ö¦í CTRL+SHIFT ¤£©ñ¦A«ö ENTER ¤@»ô¿é¤J¤½¦¡
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¥»©«³Ì«á¥Ñ abc9gad2016 ©ó 2016-11-21 17:47 ½s¿è

¦^´_ 9# 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)

¥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)))))

TOP

        ÀR«ä¦Û¦b : ­n¥Î¤ß¡A¤£­n¾Þ¤ß¡B·Ð¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD