
比之前的好点,还是有点麻烦
=LET(a,{"ABC","ACB","BAC","BCA","CAB","CBA"},f,LAMBDA(x,UNIQUE(IFERROR(REGEXREPLACE(a,"["&CONCAT(IF(x="√","",A2:A4))&"]",),a),1)),z,REDUCE(A2:A4,B1:O1,LAMBDA(s,n,LET(p,f(INDEX(B2:O4,,n)),TOCOL(s&","&IF(LEFT(p)=RIGHT(s),"",RIGHT(s))&p)))),DROP(TEXTSPLIT(@SORTBY(z,LEN(z)),","),,1))
=SUM(LEN(B8#)-1)+1