Excel中如何删除同一列中,相邻的两个重复数据,并合并后一列数据?详情见...答:D2单元格输入公式=IFERROR(IF(COLUMN()=4,INDEX(A:A,SMALL(IF($A$2:$A$100<>$A$3:$A$101,ROW(A$2:A$100)),ROW(A1))),SUM(INDIRECT("B"&SMALL(IF(($A$2:$A$100=C2),ROW(A$2:A$100)),COUNTIF(C$2:C2,C2))&":B"&SMALL(IF(($A$2:$A$100=C2)*($A$3:$A$...