excel多个单元格去重复、去零值后合并到一个单元格,并用逗号隔开?_百 ...答:在a15输入下面的公式试试。=CONCATENATE(A5,IF(OR(A6="",COUNTIF(A5:A5,A6)),"",IF(A5="","",",")&","&A6),IF(OR(A7="",COUNTIF(A5:A6,A7)),"",IF(A6="","",",")&","&A7),IF(OR(A8="",COUNTIF(A5:A7,A8)),"",IF(A7="","",",")&","&A8),IF(OR(...
怎么把Excel里面几个单元格的数据内容合并到一个单元格里,而且还把重复...答:数据放在B列 A!=COUNTIF(B$1:B1,B1)C1=IF(A1=1,"、"&B1&IF(ISERROR(VLOOKUP(1,A2:C11,3,)),"",VLOOKUP(1,A2:C11,3,)),"")两个公式向下啊复制 D1=SUBSTITUTE(C1,"、","",1)