|
- Sub Macro1()
- Dim arr, brr, d, i&, s&, n&
- Set d = CreateObject("scripting.dictionary")
- arr = Range("a1").CurrentRegion
- ReDim brr(1 To UBound(arr), 1 To 3)
- For i = 2 To UBound(arr)
- zf = arr(i, 1) & "," & arr(i, 3)
- If Not d.exists(zf) Then
- s = s + 1
- d(zf) = s
- brr(s, 1) = arr(i, 1)
- brr(s, 2) = arr(i, 3)
- brr(s, 3) = 1
- Else
- n = d(zf)
- brr(n, 3) = brr(n, 3) + 1
- End If
- Next
- [h:j] = ""
- [h1:j1] = Array("机构简称", "联系机构", "紧密度")
- Range("h2").Resize(s, 3) = brr
- End Sub
复制代码 |
|