怎么求两组数据的不重复项(类似于数学中的并集运算)

jodszx20160202 · 发表于 2018-3-27 23:27

如:｛1,2,3｝与｛5,7｝,结果应得｛1,2,3,5,7｝;
｛q,2,c｝与｛p,c,4｝,结果应得｛q,2,p,c,4｝;

数据顺序不限
请问怎么写公式呢？

hcm19522 · 发表于 2018-3-28 14:11

(先)E2:H5=IF(ISERR(FIND(","&TRIM(MID(SUBSTITUTE($A2,",",REPT(" ",99)),COLUMN(A1)*99-98,99))&",",",,"&$B2&",")),","&TRIM(MID(SUBSTITUTE($A2,",",REPT(" ",99)),COLUMN(A1)*99-98,99)),"")

D2:D5=MID(E2&F2&G2&H2,2,99)&","&B2

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

[求助] 怎么求两组数据的不重复项(类似于数学中的并集运算)