|
- Sub Macro1()
- Dim arr, brr, d, i&, k, j%
- Set d = CreateObject("scripting.dictionary")
- r = [a:b].Find("*", searchdirection:=xlPrevious).Row
- arr = Range("a1:b" & r)
- ReDim brr(1 To 20000, 1 To 12)
- For i = 1 To r - 5 Step 6
- n = n + 1: s = 0
- For j = 1 To 2
- For k = i To i + 5
- If Not d.exists(arr(k, j)) And arr(k, j) <> "" Then s = s + 1: brr(n, s) = arr(k, j): d(arr(k, j)) = ""
- Next
- Next
- d.RemoveAll
- Next
- Range("u1").Resize(n, 12) = brr
- End Sub
复制代码 |
|