|
发表于 2015-4-6 09:19
|
显示全部楼层
本楼为最佳答案
- Sub tt()
- arr = Range("c3:p11")
- ReDim brr(1 To UBound(arr), 1 To 4)
- Set d = CreateObject("scripting.dictionary")
- For i = 2 To UBound(arr)
- If arr(i, 5) = "已成" Then
- x = arr(i, 3): y = arr(i, 4)
- cj = arr(i, 9) '成交数量
- If Not d.exists(x) Then
- n = n + 1
- d(x) = n
- brr(n, 1) = x
- End If
- p = d(x)
- c = IIf(y = "卖出", 4, IIf(arr(i, 12) = "信用交易", 3, 2))
- brr(p, c) = brr(p, c) + cj
- End If
- Next
- [d21].Resize(n, 4) = brr
- End Sub
复制代码 |
|