大佬们，怎么去除数组中重合的部分？

人间油物 · 发表于 2023-5-28 18:06

z55660701 发表于 2023-5-28 17:59
谢谢大佬！！！！

可以右下角上表示感谢喔

橒♂蝣 · 发表于 2023-5-28 18:07

=LET(x,TRIM(MID(SUBSTITUTE(B2,",",REPT(" ",99)),ROW(A1:A8)*99-98,99)),
y,TRIM(MID(SUBSTITUTE(D2,",",REPT(" ",99)),ROW(A1:A6)*99-98,99)),
z,FILTER(x,ISNUMBER(XMATCH(x,y))),
a,FILTER(x,ISERROR(XMATCH(x,y))),
b,FILTER(y,ISERROR(XMATCH(y,x))),
TEXTJOIN(",",1,a,b)
)

shaowu459 · 发表于 2023-5-28 18:36

合并，逗号拆分，unique保留只出现过一次的内容，再合并

咔咔乱坠 · 发表于 2023-5-28 19:43

=CONCAT(UNIQUE(TEXTSPLIT(CONCAT(B2,",",D2),,","),,1)&",")

复制代码

静听溪流 · 发表于 2023-5-28 19:54

=TEXTJOIN(",",,FILTERXML("<a><b>"&SUBSTITUTE(B2&","&D2,",","</b><b>")&"</b></a>","//b[not(preceding::*=. or following::*=.)]"))

jisijie630 · 发表于 2023-5-28 20:29

=TEXTJOIN(",",1,IF(MMULT(1-ISERR(FIND(","&ROW(1:99)-1&",",","&B2:D2&",")),Z1:Z3+1)=1,ROW(1:99)-1,""))

sayhi95 · 发表于 2023-5-29 08:26

=TEXTJOIN(",",,UNIQUE(TEXTSPLIT(B2&","&D2,,","),,1))

复制代码

戴智彤 · 发表于 2023-5-29 11:28

=UNIQUE(TEXTSPLIT(b2&","&d2,","),TRUE,TRUE)

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

[求助] 大佬们，怎么去除数组中重合的部分？