本帖最后由 满坛皆为吾师 于 2020-5-19 21:21 编辑
有点坑 D2 234
=TEXT(MIN(IF(MMULT(--MID(TEXT(BASE(ROW(1:511),2),REPT(0,9)),COLUMN(A:I),1),C1:C9+1)=B2,--SUBSTITUTE(MID(CONCAT(IF(-MID(TEXT(BASE(ROW(1:511),2),REPT(0,9)),COLUMN(A:I),1),MID(A2,COLUMN(A:I),1),"!")),ROW(1:511)*9-8,9),"!",))),REPT(0,B2))
砍一点 D2 202
=TEXT(MIN(IF(LEN(SUBSTITUTE(BASE(ROW(1:511),2),0,))=B2,--SUBSTITUTE(MID(CONCAT(IF(-MID(TEXT(BASE(ROW(1:511),2),REPT(0,9)),COLUMN(A:I),1),MID(A2,COLUMN(A:I),1),"!")),ROW(1:511)*9-8,9),"!",))),REPT(0,B2))
or I11下拉
=TEXT(MIN(IF(LEN(SUBSTITUTE(BASE(ROW($1:$511),2),0,))=G11,--SUBSTITUTE(MID(CONCAT(IF(-MID(TEXT(BASE(ROW($1:$511),2),REPT(0,9)),COLUMN(A:I),1),MID(F11,COLUMN(A:I),1),"!")),ROW($1:$511)*9-8,9),"!",))),REPT(0,G11))
|