单元格内排序

maxmin168

C列是希望的结果，如果A列的部分内容存在于B列，则将其放在单元格最右。

表格.rar (6.52 KB, 下载次数: 23)

2024-6-19 10:12 上传

点击文件名下载附件

你是那块小饼干

看不懂你的需求

sandays

=REDUCE(A2,B$2:B$5,LAMBDA(x,y,IF(LEN(SUBSTITUTE(x,y,))<>LEN(x),SUBSTITUTE(x,y,)&y,x)))

袁勇

=IFERROR(SUBSTITUTE(A2,LOOKUP(1,0/FIND(B$2:B$5,A2),B$2:B$5),)&LOOKUP(1,0/FIND(B$2:B$5,A2),B$2:B$5),A2)

part98

=LET(s,FILTER($B$2:$B$5,ISNUMBER(FIND($B$2:$B$5,A2))),IF(AND(ISERR(s)),A2,TEXTJOIN(,,TEXTSPLIT(A2,s,,1),s)))

我走我流

wps   =REGEXP(A2,"(.*)("&TEXTJOIN("|",1,$B$2:$B$5)&")(.*)",2,"\1\3\2")

36 5 =IFNA(REGEXREPLACE(A2,"(.*)("&TEXTJOIN("|",1,$B$2:$B$5)&")(.*)","$1$3$2"),A2)

E学子

1. =LET(a,$B$2:$B$5,b,A2,REDUCE(b,FILTER(a,ISNUMBER(FIND(a,b)),""),LAMBDA(x,y,SUBSTITUTE(x,y,)&y)))

复制代码

leepoison

=LET(N,"已发|/已领取|未付|未结算",MAP(A2:A7,LAMBDA(x,IFERROR(REGEXP(x,N,2),"")&CONCAT(IFERROR(REGEXP(x,N),"")))))

=LET(N,TEXTJOIN("|",,$B$2:$B$5),MAP(A2:A7,LAMBDA(x,IFERROR(REGEXP(x,N,2),"")&CONCAT(IFERROR(REGEXP(x,N),"")))))

maxmin168

袁勇 发表于 2024-6-19 10:25
=IFERROR(SUBSTITUTE(A2,LOOKUP(1,0/FIND(B$2:B$5,A2),B$2:B$5),)&LOOKUP(1,0/FIND(B$2:B$5,A2),B$2:B$5),A ...

谢谢！只有这个2021可用，但是C4似乎需要修改一下，结果是:(本月工资已发已结算/已领取),已发存在于B列，需要在不存在于B列的已结算的右边。

象山海鲜

1. =CONCAT(MID(A2,COLUMN(A:Z),--ISERROR(0/(LOOKUP(COLUMN(A:Z),FIND(B$2:B$5,A2)+LEN(B$2:B$5)*{0,1})>COLUMN(A:Z)))={1;0}))

复制代码