excel中合并具有相同数据的两行,然后把他们的第三列的数值求和放在第三列。
仙小喵Sakulako1仙小喵Sakulako1仙小喵刘小刘12341仙小喵oscc0071X_Ran_刘小刘12341X_Ran_刘小刘12341X_Ran_胖胖熊20...
仙小喵 Sakulako 1
仙小喵 Sakulako 1
仙小喵 刘小刘1234 1
仙小喵 oscc007 1
X_Ran_ 刘小刘1234 1
X_Ran_ 刘小刘1234 1
X_Ran_ 胖胖熊2011 1
想得到:
仙小喵 Sakulako 2
仙小喵 刘小刘1234 1
仙小喵 oscc007 1
X_Ran_ 刘小刘1234 2
X_Ran_ 胖胖熊2011 1 展开
仙小喵 Sakulako 1
仙小喵 刘小刘1234 1
仙小喵 oscc007 1
X_Ran_ 刘小刘1234 1
X_Ran_ 刘小刘1234 1
X_Ran_ 胖胖熊2011 1
想得到:
仙小喵 Sakulako 2
仙小喵 刘小刘1234 1
仙小喵 oscc007 1
X_Ran_ 刘小刘1234 2
X_Ran_ 胖胖熊2011 1 展开
2个回答
展开全部
Sub 合单()
Dim n%, i%, O%
j = 1
For n = 2 To Application.CountA(ActiveSheet.Range("A:A"))
For O = 1 To (n - 1)
If Cells(n, 1) <> Cells(O, 1) Then
ElseIf Cells(n, 2) = Cells(O, 2) Then
GoTo PP
If Cells(n, 2) <> Cells(O, 2) Then
Else: GoTo XX
End If
End If
Next
j = j + 1
Cells(j, 5) = Cells(n, 1)
Cells(j, 6) = Cells(n, 2)
Cells(j, 7) = Cells(n, 3)
For i = (n + 1) To Application.CountA(ActiveSheet.Range("a:a"))
If Cells(n, 1) = Cells(i, 1) Then
If Cells(n, 2) = Cells(i, 2) Then
Cells(j, 7) = Cells(j, 7) + Cells(i, 3)
End If
End If
Next
PP:
XX:
Next
End Sub
Dim n%, i%, O%
j = 1
For n = 2 To Application.CountA(ActiveSheet.Range("A:A"))
For O = 1 To (n - 1)
If Cells(n, 1) <> Cells(O, 1) Then
ElseIf Cells(n, 2) = Cells(O, 2) Then
GoTo PP
If Cells(n, 2) <> Cells(O, 2) Then
Else: GoTo XX
End If
End If
Next
j = j + 1
Cells(j, 5) = Cells(n, 1)
Cells(j, 6) = Cells(n, 2)
Cells(j, 7) = Cells(n, 3)
For i = (n + 1) To Application.CountA(ActiveSheet.Range("a:a"))
If Cells(n, 1) = Cells(i, 1) Then
If Cells(n, 2) = Cells(i, 2) Then
Cells(j, 7) = Cells(j, 7) + Cells(i, 3)
End If
End If
Next
PP:
XX:
Next
End Sub
已赞过
已踩过<
评论
收起
你对这个回答的评价是?
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询