[开_20] 数组合并与置换[已总结] ★★★★

xingqiliu666

1. =LET(a,SORT(UNIQUE(INDEX($B$3:$D$18&"",MOD(SEQUENCE(48)-1,16)+1,ROUNDUP(SEQUENCE(48)/16,))),,-1),b,MMULT((a=TRANSPOSE($B$3:$B$18))*1,SEQUENCE(16)^0),c,MMULT((a=TRANSPOSE($D$3:$D$14))*1,SEQUENCE(12)^0),d,REPT(a&"</b><b>",ABS(b-c)),e,"<a><b>"&TEXTJOIN(,,d)&"</b></a>",IFERROR(INDEX(FILTERXML(e,"//b"),ROW(A1)),""))

复制代码