求大神！有附件有模拟结果，非常感谢！

jisijie630

jisijie630 发表于 2022-11-11 10:48
T39:

=T31&TEXT(SUBSTITUTE(MIN(IF(IFERROR(FIND(T31,$K32:$K41)*ISNA(MATCH($K32:$K41,TEXT(MMULT({100 ...

简化一点：

=T31&TEXT(SUBSTITUTE(MIN(IF(IFERROR(FIND(T31,$K32:$K41)*ISNA(MATCH($K32:$K41,TEXT(MMULT({1000,100,10,1},MOD(SMALL(MID($S39:S39&"0000",{1;2;3;4},1)+$S31:S31*10,{1;2;3;4}+4*COLUMN($A:A)-4),10)),"0000"),)),),$K32:$K41,9^9)/1),T31,),"000")

jisijie630

weifengcz 发表于 2022-11-11 11:59
jisijie630@老师好！AG32：AG41怎么写公式，非常感谢！

AH32:

=AF32&TEXT(SUBSTITUTE(MIN(IF(IFERROR(FIND(AF32,K$32:K$41)*ISNA(MATCH(K$32:K$41,TEXT(MMULT(MOD(SMALL(MID(AH$31:AH31&"0000",{1,2,3,4},1)+AF$31:AF31*10,{1,2,3,4}+4*ROW($1:1)-4),10),{1000;100;10;1}),"0000"),)),),K$32:K$41,9^9)/1),AF32,),"000")

weifengcz

jisijie630 发表于 2022-11-11 13:00
AH32:

=AF32&TEXT(SUBSTITUTE(MIN(IF(IFERROR(FIND(AF32,K$32:K$41)*ISNA(MATCH(K$32:K$41,TEXT(MMULT ...

非常感谢老师不厌其烦！！！！！！