贴上我的公式:
274字符长火车:
=TEXT(MIN(--SUBSTITUTE(FILTERXML("<a><b>"&TEXTJOIN("</b><b>",,SUBSTITUTE(MID(CONCAT(BASE(DECIMAL(MID(SUBSTITUTE(A2,0,"A"),COLUMN(A:I),1),36)*INT(MOD(ROW(1:512)*2/2^COLUMN(A:I),2)),36)),ROW(1:512)*9-8,9),0,""))&"</b></a>","a/b[string-length(.)="&B2&"]"),"A",0)),REPT(0,B2))
239字符稍微精简了下:
=TEXT(MIN(--FILTERXML("<a><b>"&TEXTJOIN("</b><b>",,SUBSTITUTE(MID(CONCAT(TEXT((MID(A2,COLUMN(A:I),1)+1)*INT(MOD(ROW(1:512)*2/2^COLUMN(A:I),2))-1,"0;a;0")),ROW(1:512)*9-8,9),"a",""))&"</b></a>","a/b[string-length(.)="&B2&"]")),REPT(0,B2))
再来个低版本的210字符:
=TEXT(MIN(IFERROR(--LEFT(SUBSTITUTE(SUBSTITUTE(BASE(MMULT(MID(BASE(ROW(1:511),2,9),COLUMN(A:I),1)*DECIMAL(MID(SUBSTITUTE(A2,0,"A"),COLUMN(A:I),1),36),36^(9-ROW(1:9))),36)&"!",0,""),"A",0),B2),"")),REPT(0,B2)) |