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

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

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

TOP

        ÀR«ä¦Û¦b : ½_ÁJµ²±o¶V¹¡º¡¡A¶V·|©¹¤U««¡A¤@­Ó¤H¶V¦³¦¨´N¡A´N­n¶V¦³Á¾¨Rªº¯ÝÃÌ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD