合并公式：=IF(A2=A1,"",MID(SUBSTITUTE(PHONETIC(OFFSET($A2,,,COUNTIF(A:A,A2),2)),A2,","),2,999))
换行公式：=SUBSTITUTE(E2,"@",CHAR(10))
合并公式：=IF(A2=A1,"",MID(SUBSTITUTE(PHONETIC(OFFSET($A2,,,COUNTIF(A:A,A2),2)),A2,","),2,999))
换行公式：=SUBSTITUTE(E2,"@",CHAR(10))
本文标题：Excel:同编号对应单元内容合并
本文链接：https://www.haomeiwen.com/subject/toyjihtx.html
网友评论