- Sub test()
- Dim arr(), brr()
- Dim x, y, k, m
- arr = Range("A1").CurrentRegion
- ReDim brr(1 To UBound(arr), 1 To 3)
- For x = 2 To UBound(arr)
- For y = 1 To k
- If arr(x, 1) = brr(y, 1) Then
- m = 1
- brr(y, 2) = arr(x, 2) + brr(y, 2)
- brr(y, 3) = arr(x, 3) + brr(y, 3)
- End If
- Next y
- If m = 1 Then
- m = 0
- Else
- k = k + 1
- brr(k, 1) = arr(x, 1)
- brr(k, 2) = arr(x, 2)
- brr(k, 3) = arr(x, 3)
- End If
- Next x
- Range("f2").Resize(UBound(arr), 3) = brr
- End Sub
复制代码 |