请老师用公式，把两行相同数从小到大显示出来，谢谢！

cartel · 发表于 2024-6-14 17:05

无关岁月 · 发表于 2024-6-14 17:13

=LET(_a,TEXTSPLIT(E1,,","),TEXTJOIN(",",,SORT(FILTER(_a,ISNUMBER(FIND(","&_a&",",","&E2&","))))))

复制代码

windshc · 发表于 2024-6-14 17:34

=ARRAYTOTEXT(SORT(FILTER(TEXTSPLIT(E1,","),ISNUMBER(FIND(","&TEXTSPLIT(E1,",")&",",","&E2))),1,1,1))

bsgn2017 · 发表于 2024-6-14 17:48

ARRAYTOTEXT(TOCOL(1/(1/LET(a,TOCOL(TEXTSPLIT(E1&","&E2,",")),b,ROW(1:17),(MATCH(a,a,)<>b)*a)),3))

复制代码

顺序无所谓吧？

cartel · 发表于 2024-6-14 17:52

bsgn2017 发表于 2024-6-14 17:48
顺序无所谓吧？

把相同数，从小到大排列，谢谢

bsgn2017 · 发表于 2024-6-14 17:53

cartel 发表于 2024-6-14 17:52
把相同数，从小到大排列，谢谢

=ARRAYTOTEXT(SORT(TOCOL(1/(1/LET(a,TOCOL(TEXTSPLIT(E1&","&E2,",")),b,ROW(1:17),(MATCH(a,a,)<>b)*a)),3)))

复制代码

cartel · 发表于 2024-6-14 17:54

无关岁月发表于 2024-6-14 17:13

老师好！
结果，相同数要自动从小到大排列

mykitami · 发表于 2024-6-14 17:55

=LET(a,TEXTSPLIT(E2,,",",1),TEXTJOIN(",",,SORT(FILTER(a,ISNUMBER(MATCH(a,TEXTSPLIT(E1,,",",1),))))))

hugeinfo · 发表于 2024-6-14 17:57

=TEXTJOIN(",",,SORT(FILTER(TEXTSPLIT(E2,",",),BYCOL(N(TEXTSPLIT(E1,,",")=TEXTSPLIT(E2,",",)),LAMBDA(x,SUM(x)))),,1,1))

一杯绿茶来了 · 发表于 2024-6-14 21:02

=ARRAYTOTEXT(SORT(FILTER(TEXTSPLIT(E2,,",")*1,BYROW(N(TEXTSPLIT(E2,,",")=TEXTSPLIT(E1,",")),SUM))))

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

[已解决] 请老师用公式，把两行相同数从小到大显示出来，谢谢！