请老师调整下这个公式，找出两行的相同数，从小到大排列，谢谢

cartel · 发表于 2024-7-12 18:48

part98 · 发表于 2024-7-12 19:07

=LET(s,TEXTSPLIT(E1&","&E2,,","),TEXTJOIN(",",,SORT(--UNIQUE(VSTACK(UNIQUE(s),UNIQUE(s,,1)),,1),,1)))

复制代码

quqiyuan · 发表于 2024-7-12 19:16

=TEXTJOIN(",",,SORT(IF(ISNUMBER(FIND(TEXTSPLIT(E1,","),E2)),TEXTSPLIT(E1,","),"")))

复制代码

清梦扰 · 发表于 2024-7-12 19:31

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

comeet · 发表于 2024-7-12 20:01

=ARRAYTOTEXT(SORT(TEXTSPLIT(E1,TEXTSPLIT(E1,TEXTSPLIT(E2,","),,1),,1)))

剑指E · 发表于 2024-7-12 20:16

=LET(x,TEXTSPLIT(E1,","),TEXTJOIN(",",,SORT(XLOOKUP(TEXTSPLIT(E2,","),x,x,""))))

复制代码

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

[已解决] 请老师调整下这个公式，找出两行的相同数，从小到大排列，谢谢