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

·j´M¦r¦ê¦r¼Æ¡A¦p¦ó¤U¤½¦¡©O?

·j´M¦r¦ê¦r¼Æ¡A¦p¦ó¤U¤½¦¡©O?

Â^¨ú1.PNG
2021-8-3 07:59


¤j®a¦­¡A

·Q½Ð°Ý¦p¹ÏªºF2~F4¤½¦¡¡A¸Ó¦p¦ó¤U¤~¯àÅã¥Ü­È©O?

F2·Q·j´M¦³¥]§t1~10ªº¦r¦ê¡A¦Ó§Ú¥ÎCOUNTIF($A$2:$A$4,E2&"*")¡A«oµLªk§ä¥X­È¡A¤£ª¾¹D°ÝÃD¥X¦b­þ?


ªþ¤WÀɮסG ¬¡­¶Ã¯1.zip (7.12 KB)


·Q³Â·Ð¦U¦ì¨ó§U´£¨Ñ·Qªk¡AÁÂÁ±z­Ì¡C

·PÁÂML089©M­ã´£³¡ªLªº¼ö¤ßÀ°¦£¡A¤½¦¡¥i¥H¨Ï¥Î!

TOP

¼W¥[Ãä¬Éª¬ªp§PÂ_¡A´î¤Ö¸ê®Æ®æ¦¡¤£¤@¼Ë¿ù»~
=IF(E2="","",SUM(COUNTIF(A:A,{"","* ","*,"}&SUBSTITUTE(E2,"~","?")&{"";" *";",*"})))

¼W¥[3ºØÃä¬É§PÂ_  ""¡A" "¡A","
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

2¼Ó¤½¦¡­×¥¿
=SUM(COUNTIF($A$2:$A$19,{"","* "}&SUBSTITUTE(E2,"~","?")&{"";",*"}))
¤À¹j²Å¸¹¬° "," + " "(ªÅ®æ)

¸ê®Æ¤À¹j®æ¬O­n²Î¤@¡A¤£µMCOUNTIF¨ç¼Æ²Î­p®e©ö¥X¿ù¡A¥i¥H°Ñ¦Ò3¼Ó ÄYÂÔ¤½¦¡
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

1~10
91~100
·|¦³¿ù»~~~

°}¦C:
=COUNT(FIND(", "&E2&",",", "&A$2:A$19&","))

ÄYÂÔ¨Ç:
=COUNT(FIND(","&E2&",",","&SUBSTITUTE(A$2:A$19," ",)&","))

TOP

=COUNTIF($A$2:$A$4,"*"&SUBSTITUTE(E2,"~","~~")&"*")
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¦¨¥\¬OÀuÂIªºµo´§¡A¥¢±Ñ¬O¯ÊÂIªº²Ö¿n¡C
ªð¦^¦Cªí ¤W¤@¥DÃD