Excel:同编号对应单元内容合并
2020-04-20 本文已影响0人
王生28
合并公式：=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))
