|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
- Sub 搜索叠加()
- Dim d As Object, arr, i%, j%, sr$, s, brr(1 To 5000, 1 To 5), a, k%
- Set d = CreateObject("scripting.dictionary")
- arr = Range("a4:e" & Range("a" & Rows.Count).End(xlUp).Row)
- Range("i5:m10000").ClearContents
- For i = 2 To UBound(arr)
- d(arr(i, 1) & "," & arr(i, 2)) = d(arr(i, 1) & "," & arr(i, 2)) & "," & i
- Next
- For Each a In d.keys
- k = k + 1
- brr(k, 1) = Split(a, ",")(0): brr(k, 2) = Split(a, ",")(1)
- sr = d(a)
- s = Split(sr, ",")
- For i = 1 To UBound(s)
- brr(k, 3) = brr(k, 3) + arr(s(i), 3)
- brr(k, 4) = brr(k, 4) + arr(s(i), 4)
- brr(k, 5) = brr(k, 5) + arr(s(i), 5)
- Next
- Next
- Range("i5").Resize(k, 5) = brr
- End Sub
复制代码 |
|