|
- Sub aaa()
- Dim arr, i&, r&, d As Object, c
- Set d = CreateObject("scripting.dictionary")
- arr = [a1].CurrentRegion
- For i = 2 To UBound(arr)
- If InStr(d(arr(i, 2)) & ",", "," & arr(i, 1) & ",") = 0 Then d(arr(i, 2)) = d(arr(i, 2)) & "," & arr(i, 1)
- Next i
- ReDim arr(1 To d.Count, 1 To 2)
- For Each c In d.keys
- r = r + 1
- arr(r, 1) = c
- arr(r, 2) = UBound(Split(d(c), ","))
- Next c
- [d2].Resize(r, 2) = arr
- End Sub
复制代码 |
|