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

gaishutsusuru

¤U¸ü (16.17 KB)

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)

¤U¸ü¦¸¼Æ: 6

2021-8-3 07:58

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

ML089

=COUNTIF($A$2:$A$4,"*"&SUBSTITUTE(E2,"~","~~")&"*")

­ã´£³¡ªL

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

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

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

ML089

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

¸ê®Æ¤À¹j®æ¬O­n²Î¤@¡A¤£µMCOUNTIF¨ç¼Æ²Î­p®e©ö¥X¿ù¡A¥i¥H°Ñ¦Ò3¼Ó ÄYÂÔ¤½¦¡

ML089

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

¼W¥[3ºØÃä¬É§PÂ_  ""¡A" "¡A","

gaishutsusuru

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