|
发表于 2012-10-13 12:19
|
显示全部楼层
本楼为最佳答案
fgt258 发表于 2012-10-13 12:14
编号提取不重复,相对应编号的 "数量,金额" 累加 ;; "重量,去向" 照搬(因为他们都是一样的,只要和编号对 ...
看看这样可以不??- Sub LK()
- g = Timer
- Dim i As Long, arr(), brr(1 To 60000, 1 To 5), k As Long, h As Long, d As Object
- Set d = CreateObject("SCRIPTING.DICTIONARY")
- r = Cells(Rows.Count, 1).End(3).Row
- arr = Range("a2:e" & r).Value
- For i = 1 To r - 1
- If d.Exists(arr(i, 1)) Then
- h = d(arr(i, 1))
- brr(h, 2) = brr(h, 2) + arr(i, 2)
- brr(h, 4) = brr(h, 4) + arr(i, 5)
- Else
- k = k + 1
- d(arr(i, 1)) = k
- brr(k, 1) = arr(i, 1)
- brr(k, 2) = arr(i, 2)
- brr(k, 3) = arr(i, 3)
- brr(k, 4) = arr(i, 5)
- brr(k, 5) = arr(i, 4)
- End If
- Next
- Range("g2:k65536").ClearContents
- Range("g2").Resize(k, 5) = brr
- MsgBox Timer - g
- End Sub
复制代码 |
|