链接: https://pan.baidu.com/s/1nH_d1MiZ6c7GoJh93uRS0Q?pwd=dhi3 提取码: dhi3 复制这段内容后打开百度网盘手机App，操作更方便哦
开始吧
=LET(a,HSTACK('1:6'!$A$1:$D$5),x,SEQUENCE(,24),y,TAKE(a,1,24),b,FILTER(x,y=TAKE(a,1,1)),c,FILTER(x,y=B$1),d,CHOOSECOLS(a,SORT(HSTACK(b,c),,,1)),e,TAKE(d,-4,12),f,TAKE(d,-4,-11),p,TEXTJOIN(,,IF(e=$A2,$A2&f,"")),j,SUBSTITUTE(p,$A2,"+"),EVALUATE(j))
开始吧
=LET(a,HSTACK('1:6'!$A$1:$D$5),x,SEQUENCE(,24),y,TAKE(a,1,24),b,FILTER(x,y=TAKE(a,1,1)),c,FILTER(x,y=B$1),d,CHOOSECOLS(a,SORT(HSTACK(b,c),,,1)),e,TAKE(d,-4,12),f,TAKE(d,-4,-11),p,TEXTJOIN(,,IF(e=$A2,$A2&f,"")),j,SUBSTITUTE(p,$A2,"+"),EVALUATE(j))
