- Sub Macro1()
- Dim arr, brr, d, i&, s&, n&
- Set d = CreateObject("scripting.dictionary")
- arr = Sheet2.Range("a1").CurrentRegion
- ReDim brr(1 To 2000, 1 To 7)
- For i = 2 To UBound(arr)
- If Not d.exists(arr(i, 4)) Then
- s = s + 1
- d(arr(i, 4)) = s
- brr(s, 1) = arr(i, 4)
- brr(s, 2) = arr(i, 6)
- brr(s, 3) = arr(i, 2)
- brr(s, 4) = arr(i, 2)
- If arr(i, 5) = "男" Then brr(s, 5) = 1 Else brr(s, 6) = 1
- brr(s, 7) = 1
- Else
- n = d(arr(i, 4))
- brr(n, 4) = arr(i, 2)
- If arr(i, 5) = "男" Then brr(n, 5) = brr(n, 5) + 1 Else brr(n, 6) = brr(n, 6) + 1
- brr(n, 7) = brr(s, 7) + 1
- End If
- Next
- Sheet3.Range("a2").Resize(s, 7) = brr
- End Sub
复制代码 |