5,139
社区成员
发帖
与我相关
我的任务
分享
Sub 统计()
Dim i%, j%, xrow%, rng As Range
xrow = Sheet1.UsedRange.Rows.Count
For i = 2 To xrow
Set rng = Cells(i, 1)
For j = i + 1 To xrow
If rng.Value = Cells(j, 1) And rng.Value <> "" Then
Cells(i, 2).Value = Cells(i, 2).Value & "," & Cells(j, 2).Value
Rows(j).Delete
End If
Next
Next
End Sub