【求帮助】如何比较两个单元格里面的内容是否有相同

zhumumu1816 · 发表于 2025-6-9 14:59

=IF(SUM(ISNUMBER(FIND(TEXTSPLIT(B2,"，",,1),C2))^1),"含有","不包含")

复制代码

hcm19522 · 发表于 2025-6-9 15:08

D2{=IF(COUNT(0/(FIND(TRIM(MID(SUBSTITUTE(B2,"，",REPT(" ",29)),COLUMN(A:E)*29-28,29)),"@"&C2)>1)),"含有相似","不相似")

mao12306 · 发表于 2025-6-9 15:19

=IF(COUNT(MAP(TEXTSPLIT(B2,,"，",1)&"，",LAMBDA(x,FIND(x,C2&"，")))),"含有相似","不相似")

复制代码

mjm04 · 发表于 2025-6-9 15:36

本帖最后由 mjm04 于 2025-6-9 15:37 编辑

只针对对比内容全部是中文-字符的情况

=SUM(N(REGEXP(B2,REGEXP(C2,"[一-龢]+"),1)))

下拉；数量代表有几个词是一样的

沈默00 · 发表于 2025-6-9 15:43

=BYROW(B2:B7,LAMBDA(x,IF(SUM(N(ISNUMBER(FIND(REGEXP(OFFSET(x,,1),"[^，]+"),x)))),"相似","不相似")))

hcm19522 · 发表于 2025-6-9 16:01

D2{=IF(COUNT(FIND(" "&TRIM(MID(SUBSTITUTE(TRIM(SUBSTITUTE(B2,"，"," " ))," ",REPT(" ",29)),COLUMN(A:E)*29-28,29))&" "," "&TRIM(SUBSTITUTE(C2,"，"," " ))&" ")),"含有相似","不相似")

你是那块小饼干 · 发表于 2025-6-9 16:13

=LET(_数据1,UNIQUE(TEXTSPLIT(TEXTJOIN("，",TRUE,B2:B7),,"，",TRUE)),_数据2,UNIQUE(TEXTSPLIT(TEXTJOIN("，",TRUE,C2:C7),"，",,TRUE),1),FILTER(_数据2,BYCOL(_数据2=_数据1,OR)))

xtmyd5156 · 发表于 2025-6-11 12:34

=TOCOL(BYCOL(UNIQUE(REGEXP(CONCAT(B2:B7),"[^，]+"),1),LAMBDA(X,IF(REGEXP(ARRAYTOTEXT(C2:C7),X,1),X,\))),3)

复制代码

yys5161 · 发表于 2025-6-11 15:33

这个比较复杂了，前来学习的。

cpa_cpv · 发表于 2025-6-11 15:46

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

[求助] 【求帮助】如何比较两个单元格里面的内容是否有相同

点评