...第一列如果相同,则合并第二列中的值到一个单元格,中间用逗号隔开_百 ...答:假定原数据在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)) 下拉填充
...中相同项以及其对应的内容合并至同一个单元格内答:公式为:=IF(A1="","",TEXTJOIN(",",,A1,IFERROR(OFFSET(B1,,,MATCH(,0/(A2:A999<>""),),),B1)))数组公式,按ctrl+shift+enter产生花括号。如图所示: