函数题目！

=REDUCE(A1:C1,A2:A5&9&B2:B5&9&C2:C5,LAMBDA(x,y,VSTACK(x,TRANSPOSE(TEXTSPLIT(y,",",9,,,"")))))

不感兴趣

开通SVIP免广告

常规写法=REDUCE(A1:C1,A2:A5,LAMBDA(x,y,VSTACK(x,IFNA(HSTACK(y,TEXTSPLIT(OFFSET(y,,1),,","),TEXTSPLIT(OFFSET(y,,2),,",")),""))))

=ifna(reduce(a1:c1,a2:a5,lambda(x,y,vstack(x,transpose(reduce(,regexp(offset(y,,,,3),"\Pp",3),vstack)))),"")

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

分享到: