|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
- Sub test()
- Dim r%, i%
- Dim arr, brr
- Dim d As Object
- Set d = CreateObject("scripting.dictionary")
- With Worksheets("结果")
- r = .Cells(.Rows.Count, 1).End(xlUp).Row
- arr = .Range("a2:d" & r)
- For i = 1 To UBound(arr)
- xm = arr(i, 1) & "+" & arr(i, 3)
- If InStr(arr(i, 2), "强制") <> 0 Then
- d(xm) = d(xm) + arr(i, 4)
- End If
- Next
- ReDim brr(1 To UBound(arr), 1 To 1)
- For i = 1 To UBound(arr)
- xm = arr(i, 1) & "+" & arr(i, 3)
- If d.exists(xm) Then
- brr(i, 1) = d(xm)
- End If
- Next
- .Range("e2").Resize(UBound(brr), 1) = brr
- End With
- End Sub
复制代码 |
|