合并编码排序

=LET(x,TEXTSPLIT(TEXTJOIN(";",,A1:A4),"-",";",)*1,SORTBY(A1:B4,TAKE(x,,1),1,DROP(TAKE(x,,2),,1),1,TAKE(x,,-1),1))

这个直接=sort(A1:B4)不就行了吗

2025-03-17 06:53广告

说一下排序规则看图片数据 A列升序即可

=EVALUATE(SUBSTITUTE(INDEX($F$2:$F$32,MATCH(L2,$B$2:$B$32,)),"w",K2))

=LET(y,CEILING(L2,1),x,FILTER(CHOOSECOLS($C$2:$F$32,IF(y<1,1,IF(y<=3,INT(y),4))),$B$2:$B$32=M2),IFERROR(x*1,EVALUATE(SUBSTITUTE(x,"w",y))))

下载贴吧APP
看高清直播、视频！

分享到: