EXCEL判断第一列如果相同,则合并第二列中的值到一个单元格,中间用逗号...答:假定原数据在A、B两列 C1 =IF(COUNTIF(A$1:A1,A1)>1,"",A1) 下拉填充 D1 =IF(COUNTIF(A$1:A1,A1)>1,"",SUBSTITUTE(SUBSTITUTE(PHONETIC(OFFSET(A1,,,COUNTIF(A:A,A1),2)),A1,","),",","",1)) 下拉填充
excel如何比较两列重复值,如果相同,则将第三列数相加答:=SUM(SUMIFS(C$1:C$4,A$1:A$4,E1,B$1:B$4,F1),SUMIFS(C$1:C$4,A$1:A$4,F1,B$1:B$4,E1))