·j´M¦r¦ê¦r¼Æ¡A¦p¦ó¤U¤½¦¡©O?
- ©«¤l
- 146
- ¥DÃD
- 46
- ºëµØ
- 0
- ¿n¤À
- 220
- ÂI¦W
- 0
- §@·~¨t²Î
- 7
- ³nÅ骩¥»
- 2010
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2014-2-19
- ³Ì«áµn¿ý
- 2023-8-31
|
·j´M¦r¦ê¦r¼Æ¡A¦p¦ó¤U¤½¦¡©O?
¤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 |
|
|
|
|
|
|
- ©«¤l
- 2025
- ¥DÃD
- 13
- ºëµØ
- 0
- ¿n¤À
- 2053
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- Office2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_¥«
- µù¥U®É¶¡
- 2011-3-2
- ³Ì«áµn¿ý
- 2024-3-14
|
=COUNTIF($A$2:$A$4,"*"&SUBSTITUTE(E2,"~","~~")&"*") |
|
{...} ªí¥Ü»Ýn¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡
|
|
|
|
|
- ©«¤l
- 2834
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 2890
- ÂI¦W
- 0
- §@·~¨t²Î
- ¡e²¤¡f
- ³nÅ骩¥»
- ¡e²¤¡f
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¡e²¤¡f
- µù¥U®É¶¡
- 2013-5-13
- ³Ì«áµn¿ý
- 2024-11-23
|
1~10
91~100
·|¦³¿ù»~~~
°}¦C:
=COUNT(FIND(", "&E2&",",", "&A$2:A$19&","))
ÄYÂÔ¨Ç:
=COUNT(FIND(","&E2&",",","&SUBSTITUTE(A$2:A$19," ",)&",")) |
|
|
|
|
|
|
- ©«¤l
- 2025
- ¥DÃD
- 13
- ºëµØ
- 0
- ¿n¤À
- 2053
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- Office2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_¥«
- µù¥U®É¶¡
- 2011-3-2
- ³Ì«áµn¿ý
- 2024-3-14
|
2¼Ó¤½¦¡×¥¿
=SUM(COUNTIF($A$2:$A$19,{"","* "}&SUBSTITUTE(E2,"~","?")&{"";",*"}))
¤À¹j²Å¸¹¬° "," + " "(ªÅ®æ)
¸ê®Æ¤À¹j®æ¬On²Î¤@¡A¤£µMCOUNTIF¨ç¼Æ²Îp®e©ö¥X¿ù¡A¥i¥H°Ñ¦Ò3¼Ó ÄYÂÔ¤½¦¡ |
|
{...} ªí¥Ü»Ýn¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡
|
|
|
|
|
- ©«¤l
- 2025
- ¥DÃD
- 13
- ºëµØ
- 0
- ¿n¤À
- 2053
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- Office2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_¥«
- µù¥U®É¶¡
- 2011-3-2
- ³Ì«áµn¿ý
- 2024-3-14
|
¼W¥[Ãä¬Éª¬ªp§PÂ_¡A´î¤Ö¸ê®Æ®æ¦¡¤£¤@¼Ë¿ù»~
=IF(E2="","",SUM(COUNTIF(A:A,{"","* ","*,"}&SUBSTITUTE(E2,"~","?")&{"";" *";",*"})))
¼W¥[3ºØÃä¬É§PÂ_ ""¡A" "¡A"," |
|
{...} ªí¥Ü»Ýn¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡
|
|
|
|
|
- ©«¤l
- 146
- ¥DÃD
- 46
- ºëµØ
- 0
- ¿n¤À
- 220
- ÂI¦W
- 0
- §@·~¨t²Î
- 7
- ³nÅ骩¥»
- 2010
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2014-2-19
- ³Ì«áµn¿ý
- 2023-8-31
|
·PÁÂML089©Mã´£³¡ªLªº¼ö¤ßÀ°¦£¡A¤½¦¡¥i¥H¨Ï¥Î! |
|
|
|
|
|
|