拆分，合并，唯一值

大自在天 · 发表于 2024-5-8 13:57

jivy1212 · 发表于 2024-5-8 14:02

=UNIQUE(MID(TEXTJOIN(",",1,A2:A66)&REPT(A2,666),ROW(1:66)*2-1,1))

复制代码

21版

博爱风雨同舟 · 发表于 2024-5-8 14:04

UNIQUE(TEXTSPLIT(CONCAT(A2:A6&","),","),1)

hugeinfo · 发表于 2024-5-8 14:06

=UNIQUE(TEXTSPLIT(TEXTJOIN(",",,A2:A6),,","))

博爱风雨同舟 · 发表于 2024-5-8 14:09

=LET(A,TRIM(MID(SUBSTITUTE(CONCAT(A2:A6&","),",",REPT(" ",99)),SEQUENCE(20)*100-99,99)),INDEX(A,AGGREGATE(15,6,SEQUENCE(20)/(MATCH(A,A,)=SEQUENCE(20)),SEQUENCE(7))))

hugeinfo · 发表于 2024-5-8 14:11

=REDUCE("结果",A2:A6,LAMBDA(x,y,UNIQUE(VSTACK(x,TEXTSPLIT(y,,",")))))

无关岁月 · 发表于 2024-5-8 14:14

=DROP(REDUCE("",A2:A6,LAMBDA(_a,_b,UNIQUE(VSTACK(_a,TEXTSPLIT(_b,,","))))),1)

复制代码

mykitami · 发表于 2024-5-8 14:23

=UNIQUE(TEXTSPLIT(TEXTJOIN(",",,A2:A6),,",",1))

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

[求助] 拆分，合并，唯一值