本帖最后由 leepoison 于 2024-7-28 02:06 编辑
- =DROP(REDUCE("",B2:D2,LAMBDA(m,n,HSTACK(m,HSTACK(LET(a,OFFSET(n,0,0,32),b,LEFT(a,1),c,RIGHT(a,1),d,UNIQUE(c),e,MAP(d,LAMBDA(x,SUM(--TAKE(SORT(FILTER(b,c=x),,-1),4)))),f,FILTER(d,e=MAX(e)),TAKE(VSTACK(TAKE(SORT(FILTER(b,c=TAKE(f,1)),,-1),4)&TAKE(f,1),FILTER(a,c<>TAKE(f,1))),4)))))),,1)
复制代码
右拉
- =LET(a,B2:B33,b,LEFT(a,1),c,RIGHT(a,1),d,UNIQUE(c),e,MAP(d,LAMBDA(x,SUM(--TAKE(SORT(FILTER(b,c=x),,-1),4)))),f,FILTER(d,e=MAX(e)),TAKE(VSTACK(TAKE(SORT(FILTER(b,c=TAKE(f,1)),,-1),4)&TAKE(f,1),FILTER(a,c<>TAKE(f,1))),4))
复制代码 |