求助

Wendahappy

wp231957 发表于 2025-3-31 10:55
=TEXTJOIN(",",,UNIQUE(TRIM(TEXTSPLIT(TEXTJOIN(",",,B1,C1),",")),1,1))

感谢帮忙，可以了

hxj119

或者

1. =TEXTJOIN(",",,UNIQUE(TRIM(TEXTSPLIT(B1&","&C1,,",",1)),,1))

复制代码

Wendahappy

mjm04 发表于 2025-3-31 11:09
正则

=UNIQUE(REGEXP(ARRAYTOTEXT(B1:C1),"[^,\s]+"),1,1)

感谢帮忙

人有言兮是然

wp231957 发表于 2025-3-31 10:46
=UNIQUE(TRIM(TEXTSPLIT(TEXTJOIN(",",,B1,C1),",")),1,1)

借这个地方，请教个问题，textsplit，你的公式是按列，然后用unique可以得到答案。如果textsplit按行，几乎同样的公式：=UNIQUE(TRIM(TEXTSPLIT(TEXTJOIN(",",,B1,C1),,",")),1,1)，为什么得不到正确答案。这个差别是什么原因？

Wendahappy

hxj119 发表于 2025-3-31 11:04

感谢帮忙

Wendahappy

你是那块小饼干 发表于 2025-3-31 11:02
=UNIQUE(TRIM(TEXTSPLIT(TEXTJOIN(",",TRUE,B1:C1),,",",TRUE)),,TRUE)

感谢帮忙

mykitami

=LET(f,LAMBDA(x,TEXTSPLIT(SUBSTITUTE(x," ",),,",",1)),TEXTJOIN(",",,FILTER(f(B1),ISERROR(MATCH(f(B1),f(C1),)),""),FILTER(f(C1),ISERROR(MATCH(f(C1),f(B1),)),"")))

沈默00

=UNIQUE(TRIM(REGEXP(TEXTJOIN(",",,B1:C1),"[^,]+")),1,1)
=UNIQUE(REGEXP(TEXTJOIN(",",,B1:C1),"[^, ]+"),1,1)
=UNIQUE(REGEXP(CONCAT(B1:C1&","),"[^, ]+"),1,1)
=UNIQUE(REGEXP(B1&","&C1,"[^, ]+"),1,1)
写到最短了，，，

沈默00

mjm04 发表于 2025-3-31 11:09
正则

=UNIQUE(REGEXP(ARRAYTOTEXT(B1:C1),"[^,\s]+"),1,1)

现在正则越来越溜了，，，

朝露孤烟

公式较短一点。=TEXTJOIN(",",,UNIQUE(TRIM(TEXTSPLIT(B1:C1,",")),1))