|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
- Sub test()
- Dim arr
- Set d = CreateObject("scripting.dictionary")
- With Sheet2
- .Columns("E:g").Clear
- arr = .[a1].CurrentRegion
- End With
- ReDim brr(1 To UBound(arr), 1 To 3)
- For i = 2 To UBound(arr)
- ss = arr(i, 2) & arr(i, 4)
- If Not d.exists(ss) Then
- n = n + 1
- d(ss) = n
- brr(n, 1) = arr(i, 2)
- brr(n, 3) = arr(i, 4)
- brr(n, 2) = arr(i, 3)
- Else
- brr(d(ss), 2) = brr(d(ss), 2) + arr(i, 3)
- End If
- d(arr(i, 2)) = d(arr(i, 2)) + arr(i, 2)
- Next
- Sheet2.[e1:f1:g1] = Array("产品编号", "数量", "港口")
- Range("e2").Resize(UBound(brr), 3) = brr
- End Sub
复制代码 |
|