求有符号的单元格内的重复数字

q563262982 · 发表于 2019-11-10 22:17

求B2与A2单元格内相同数字的重复次数，需要区分符号。
如图，附件！

满坛皆为吾师 · 发表于 2019-11-10 22:25

本帖最后由满坛皆为吾师于 2019-11-10 22:38 编辑

C2 三键下拉
=COUNT(FIND(TEXT(MID(SUBSTITUTE(B$2,",",REPT(" ",99)),ROW($1:$9)*99-98,99),",0!,;;;i"),","&A2&","))

=COUNT(FIND(TEXT(MID(SUBSTITUTE(B$2,"/",REPT(" ",33)),ROW($1:$9)*33-32,33),"!/0!/;;;i"),"/"&A2&"/"))

q563262982 · 发表于 2019-11-10 22:34

满坛皆为吾师发表于 2019-11-10 22:25
C2 三键下拉
=COUNT(FIND(TEXT(MID(SUBSTITUTE(B$2,",",REPT(" ",99)),ROW($1:$9)*99-98,99),",0!,;;;i"), ...

非常感谢，若是“逗号，” 变成 “/” 符号需要改哪里呀？

libo5563 · 发表于 2019-11-10 23:10

函数不会，pq 凑热闹

micch · 发表于 2019-11-11 07:28

=COUNT(FIND(","&ROW($1:$99)&",",","&A2&",")*FIND(","&ROW($1:$99)&",",","&B$2&","))

复制代码

		自动登录	找回密码
密码			免费注册

[已解决] 求有符号的单元格内的重复数字

评分

点评

评分

最新热点 /1