第二问
- Sub Test()
- Dim d As Object, d1, ar, br, k, i&, m%, n%
- Set d = CreateObject("Scripting.Dictionary")
- Set d1 = CreateObject("Scripting.Dictionary")
- ar = Sheets("sheet1").UsedRange
- For i = 2 To UBound(ar)
- If Not d.Exists(ar(i, 5)) Then
- d(ar(i, 5)) = ""
- End If
- Next
- ReDim br(1 To d.Count, 1 To UBound(ar))
- For Each aa In d.keys
- k = k + 1
- n = 1
- For i = 2 To UBound(ar)
- For j = 6 To 12
- If ar(i, 5) = aa Then
- If Not d1.Exists(aa & ar(i, j)) Then
- d1(aa & ar(i, j)) = ""
- If ar(i, j) <> "" Then
- n = n + 1
- br(k, 1) = ar(i, 5)
- br(k, n) = ar(i, j)
- End If
- End If
- End If
- Next
- Next
- Next
- Sheets("sheet1").Range("aa9").Resize(d.Count, UBound(br, 2)) = br
- End Sub
复制代码 |