|
- Sub t()
- Dim arr, i&, x, d, brr, n&
- Set d = CreateObject("scripting.dictionary")
- arr = [a2:b14]
- ReDim brr(1 To UBound(arr), 1 To 2)
- For i = 2 To UBound(arr)
- x = arr(i, 1) & Abs(arr(i, 2))
- If Not d.exists(x) Then
- d(x) = i
- Else
- d.Remove (x)
- End If
- Next
- For Each x In d.items
- n = n + 1
- brr(n, 1) = arr(x, 1)
- brr(n, 2) = arr(x, 2)
- Next
- [i3].Resize(UBound(arr), UBound(arr, 2)) = brr
- End Sub
复制代码 |
|