求抽取k个数字能组成的最大数字（已结贴）

shaowu459

更新一个公式：

1. =LET(s,ROW($1:99),t,REDUCE(SUBSTITUTE(A2,",",),s,LAMBDA(x,y,IF(LEN(x)=B2,x,REPLACE(x,IFNA(MATCH(1=1,MID(x,s,1)<MID(x,s+1,1),),99),1,)))),LEFT(RIGHT(t,LEN(--t)),B2))

复制代码

象山海鲜

1. =REDUCE(,LEFT(SCAN(","&A2,SEQUENCE(B2),LAMBDA(x,y,MID(x,FIND(@SORT(DROP(DROP(TEXTSPLIT(x,,","),1),y-B2),,-1),x,2),99)))),LAMBDA(x,y,IF(-x,x,)&y))

复制代码

1. =@REDUCE(TEXTSPLIT("0,"&A2&",",,","),SEQUENCE(B2),LAMBDA(x,y,LET(m,DROP(DROP(x,1),y-B2-1),n,@SORT(m,,-1),VSTACK(IF(-@x,@x,)&n,DROP(x,MATCH(n,m,)+1)))))

复制代码

wdx223

1. =LET(a,--TEXTSPLIT(A2,,","),b,ROWS(a),REDUCE("",SEQUENCE(b),LAMBDA(x,y,LET(c,DROP(a,y-1),d,b-y+2-B2+LEN(x),IF(LEN(x)=B2,x,IF(-(0&x),x,)&IF(d,IF(@c=MAX(TAKE(c,d)),@c,""),@c))))))

复制代码

这个有点长

lws

1. =LET(u,TAKE(REDUCE(HSTACK(""," "&A2),SEQUENCE(B2)-B2,LAMBDA(X,Y,LET(n,@TAKE(X,-1,1),p,@TAKE(X,-1,-1),m,--TEXTSPLIT(REPLACE(p,1,FIND(RIGHT(n),p),""),,",",1),VSTACK(X,HSTACK(n&MAX(DROP(m,Y)),TEXTJOIN(",",,m)))))),-1,1),IF(LEN(u*1)>15,LEFT(u,15)*1&RIGHT(u,B2-15),TEXT(u,0)))

复制代码

shaowu459

改写一个：

1. =LET(u,TEXTSPLIT(A2,,","),REDUCE(,INDEX(u,SCAN(0,SEQUENCE(B2),LAMBDA(x,y,LET(t,DROP(DROP(-u,x),y-B2),x+MATCH(MIN(t),t,))))),LAMBDA(x,y,IF(-x,x,)&y)))
   

复制代码

橒♂蝣

自定义名称：aaa(A2,B2),下拉

=LAMBDA(x,y,
LET(o,--TEXTSPLIT(x,","),
n,LARGE(o,SEQUENCE(y)),
m,MAX(IF(LEN(SUBSTITUTE(x,",",""))-FIND(n,SUBSTITUTE(x,",",""))>=y-1,n)),         
rr, TEXTJOIN(",",1,DROP(CHOOSECOLS(o, SEQUENCE(COLUMNS(o)-XMATCH(m,o)+1, 1, XMATCH(m,o), 1)),,1)),
IF(y<=1,n,CONCAT(VSTACK(m,aaa(rr,y-1))))
))

wdx223

=LAMBDA(l,n,r,IF(n<2,IF(-r,r,)&MAX(l),LET(a,DROP(l,1-n),b,MAX(a),c,MATCH(b,a,),fx(DROP(l,c),n-1,IF(-r,r,)&b))))
递归，可以再砍一点

wdx223

1. =@REDUCE(0,SEQUENCE(B2),LAMBDA(x,y,LET(a,@TAKE(x,-1),b,DROP(DROP(--TEXTSPLIT(A2,,","),a),y-B2),c,MAX(b),VSTACK(IF(-@x,@x,)&c,MATCH(c,b,)+a))))

复制代码

递归改循环

346465039

1. =LET(a,TEXTSPLIT(A2,",")+0,b,SUM(COMBIN(COUNT(a),SEQUENCE(COUNT(a)))),c,BASE(SEQUENCE(b),2,COUNT(a)),d,IF(MID(c,SEQUENCE(1,COUNT(a)),1)+0,a,""),e,BYROW(d,LAMBDA(x,CONCAT(x))),MAX(FILTER(e,LEN(e)=B2)+0))

复制代码

用了穷举法，最后两行填充时会卡

shaowu459

346465039 发表于 2023-11-23 15:34
用了穷举法，最后两行填充时会卡

不只是卡的问题，数字可能会超过15位的，题目上限设定是20位，现在你的公式对长数字来说最后几位会变成0