1.先排序,按第一列,第二列 2.oldstr1=thisworkbook.worksheets("sheet1").cells(2,1).value oldstr2=thisworkbook.worksheets("sheet1").cells(2,2).value for i=3 to thisworkbook.worksheets("sheet1").usedrange.row.count if thisworkbook.worksheets("sheet1").cells(i,1).value=oldstr1 and thisworkbook.worksheets("sheet1").cells(i,2).value=oldstr2 then thisworkbook.worksheets("sheet1").cells(i-1,3).value=thisworkbook.worksheets("sheet1").cells(i-1,3).value +thisworkbook.worksheets("sheet1").cells(i,3).value '相加 thisworkbook.worksheets("sheet1").Rows(str(i) & ":" & str(i)).Select Selection.Delete Shift:=xlUp i=i-1 else oldstr1=thisworkbook.worksheets("sheet1").cells(i,1).value oldstr2=thisworkbook.worksheets("sheet1").cells(i,2).value end if next i
2.oldstr1=thisworkbook.worksheets("sheet1").cells(2,1).value
oldstr2=thisworkbook.worksheets("sheet1").cells(2,2).value
for i=3 to thisworkbook.worksheets("sheet1").usedrange.row.count
if thisworkbook.worksheets("sheet1").cells(i,1).value=oldstr1 and thisworkbook.worksheets("sheet1").cells(i,2).value=oldstr2 then
thisworkbook.worksheets("sheet1").cells(i-1,3).value=thisworkbook.worksheets("sheet1").cells(i-1,3).value +thisworkbook.worksheets("sheet1").cells(i,3).value '相加
thisworkbook.worksheets("sheet1").Rows(str(i) & ":" & str(i)).Select
Selection.Delete Shift:=xlUp
i=i-1
else
oldstr1=thisworkbook.worksheets("sheet1").cells(i,1).value
oldstr2=thisworkbook.worksheets("sheet1").cells(i,2).value end if
next i