使用公式提取两个单元格中用分隔符分开的内容的差异项

鹰fly · 发表于 2024-7-9 12:28

复制代码

mjm04 · 发表于 2024-7-9 13:31

=ARRAYTOTEXT(UNIQUE(TEXTSPLIT(TEXTJOIN(",",1,A2:B2),,",",,,""),,1))

----------------------------------------------------------
8楼的连接符用的真好啊

木槿花西月锦绣 · 发表于 2024-7-9 15:37

练习，PQ基本操作，东拼西凑

057X7 · 发表于 2024-7-9 21:24

谢谢各位，问题解决了

mykitami · 发表于 2024-7-9 21:38

=LET(a,TEXTSPLIT(A2,,",",1),TEXTJOIN(",",,FILTER(a,ISERROR(FIND(a,B2)))))

ggmmlol · 发表于 2024-7-9 23:16

秃头发师发表于 2024-7-9 10:53
UNIQUE提取只出现一次的项，终于派上用场了，思路奇妙无比啊

根本用不着UNIQUE:

袁希 · 发表于 2024-7-10 09:39

=TEXTJOIN(",",,UNIQUE(MID(A2&","&B2,SEQUENCE(LEN(A2&","&B2)-LEN(SUBSTITUTE(A2&","&B2,",",""))+1)*FIND(",",A2)-(FIND(",",A2)-1),FIND(",",A2)-1),,1))

wgreen · 发表于 2024-7-10 11:22

=TEXTJOIN(",",TRUE,TEXTSPLIT(TEXTJOIN(",",TRUE,TEXTSPLIT(A2,TEXTSPLIT(B2,","))),","))

wgreen · 发表于 2024-7-10 12:00

=UNIQUE(VSTACK(TOCOL(TEXTSPLIT(A2,",")),TOCOL(TEXTSPLIT(B2,","))),,TRUE)

我的城市你来过 · 发表于 2024-7-10 14:19

=ARRAYTOTEXT(REGEXP(SUBSTITUTES(A2,REGEXP(B2,"\d+")),"\d+"))

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

[求助] 使用公式提取两个单元格中用分隔符分开的内容的差异项