問題:合并對應品牌的全部產(chǎn)品,并去重

用這個公式可以得到對應品牌的全部產(chǎn)品名

=TEXTJOIN("、",1,IF(A2:A34=D2,B2:B34,""))

但內(nèi)容沒有去重

高階版本就只需要用textsplit分列,UNIQUE去重,在textjoin合并就行了

我沒有

我用老套分列去重套路

=TEXTJOIN("、",1,IF(MATCH(TRIM(MID(SUBSTITUTE(TEXTJOIN("、",1,IF($A$2:$A$34=D2,$B$2:$B$34,"")),"、",REPT(" ",200)),ROW($1:$50)*200-199,200)),TRIM(MID(SUBSTITUTE(TEXTJOIN("、",1,IF($A$2:$A$34=D2,$B$2:$B$34,"")),"、",REPT(" ",200)),ROW($1:$50)*200-199,200)),0)=ROW($1:$50),TRIM(MID(SUBSTITUTE(TEXTJOIN("、",1,IF($A$2:$A$34=D2,$B$2:$B$34,"")),"、",REPT(" ",200)),ROW($1:$50)*200-199,200)),""))