|
- Sub grf()
- arr = [a2].CurrentRegion
- ReDim brr(1 To 3 * UBound(arr), 1 To 3)
- Set d = CreateObject("scripting.dictionary")
- For i = 2 To UBound(arr)
- If Len(arr(i, 2)) And arr(i, 2) <> "汇总" Then
- d(arr(i, 2)) = ""
- n = n + 1
- brr(n, 1) = arr(i, 2)
- End If
- Next
- For j = 3 To 4
- For i = 2 To UBound(arr)
- brr(i, j - 1) = arr(i, j)
- If Len(arr(i, j)) And arr(i, j) <> "汇总" Then
- If Not d.exists(arr(i, j)) Then
- d(arr(i, j)) = ""
- n = n + 1
- brr(n, 1) = arr(i, j)
- Else
- brr(i, j - 1) = ""
- End If
- End If
- Next
- Next
- [g3].Resize(n, 3) = brr
- End Sub
复制代码 |
|