- =LET(f,LAMBDA(m,SUBSTITUTE(CELL("address",m),"$",)),_b,REDUCE(A2:A16&"-"&MAP(A2:A16,f),ROW(1:3),LAMBDA(x,y,LET(_a,OFFSET(A2:A16,,y),TOCOL(x&"/"&TOROW(_a&"-"&MAP(_a,f)))))),_c,REDUCE(_b,CHAR(ROW(65:68)),LAMBDA(x,y,SUBSTITUTE(x,y,))),_d,FILTER(_c,MAP(_c,LAMBDA(x,ROWS(UNIQUE(TAKE(TEXTSPLIT(x,"-","/"),,-1)))=4))),_e,MAP(_d,LAMBDA(x,PRODUCT(--TAKE(TEXTSPLIT(x,"-","/"),,1)))),_f,FILTER(_d,_e=MAX(_e)),MAP(_f,LAMBDA(x,LET(_g,TEXTSPLIT(x,"-","/"),TEXTJOIN("/",,TAKE(_g,,1)&"-row("&TAKE(_g,,-1)&")")&"="&PRODUCT(--TAKE(_g,,1))))))
复制代码 来个火车
|