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

057X7 · 发表于 2024-7-9 07:26

求助：使用公式提取两个单元格中用分隔符分开的内容的差异项，如附表中的2列与1列的差异项。

我要成为专家 · 发表于 2024-7-9 07:55

=substitutes(a2,textsplit(b2,","),"")

hugeinfo · 发表于 2024-7-9 08:04

=TEXTJOIN(",",,REDUCE("",TEXTSPLIT(A2,,","),LAMBDA(x,y,VSTACK(x,IF(ISNUMBER(FIND(y,B2)),"",y)))))

jivy1212 · 发表于 2024-7-9 08:06

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

复制代码

2019可

沈默00 · 发表于 2024-7-9 08:16

=TEXTJOIN(",",,UNIQUE(HSTACK(TEXTSPLIT($A2,","),TEXTSPLIT($B2,",")),1,1)) 下拉

ww87725244 · 发表于 2024-7-9 09:03

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

wbjjzhu · 发表于 2024-7-9 09:07

复制代码

hxj119 · 发表于 2024-7-9 10:40

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

秃头发师 · 发表于 2024-7-9 10:53

ww87725244 发表于 2024-7-9 09:03
=TEXTJOIN(",",,UNIQUE(TEXTSPLIT(A2&","&B2,","),1,1))

UNIQUE提取只出现一次的项，终于派上用场了，思路奇妙无比啊

你是那块小饼干 · 发表于 2024-7-9 11:46

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

复制代码

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

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