函数题目！

=REDUCE(A1:B1,B2:B5,LAMBDA(x,y,VSTACK(x,IF(B2:C2,T(y:A5),BYROW(WRAPROWS(SEQUENCE(y),50),COUNT)))))

2025-03-01 22:36广告

=REDUCE(A1:B1,A2:A6,LAMBDA(x,y,VSTACK(x,LET(a,OFFSET(y,,1),b,INT(a/50),c,MOD(a,50),IFNA(HSTACK(y,IF(b=0,c,VSTACK(REPTARRAY(50,b),c))),y)))))

写出来了！=TEXT({1,0},TOCOL("\"&A2:A5&";;"&--(0&50-DDB(COLUMN(A:I)*50,B2:B5,1,1)),3))

贴吧老题了。

=TEXTSPLIT(CONCAT(REPT(A2:A5&";50,",B2:B5/50)&A2:A5&";"&MOD(B2:B5,50)&","),";",",",1)

下载贴吧APP
看高清直播、视频！

分享到: