|
- Sub Macro1()
- Dim arr, brr, d, d2, i&
- Set d = CreateObject("scripting.dictionary")
- Set d2 = CreateObject("scripting.dictionary")
- arr = Range("a1").CurrentRegion
- brr = Range("c1").CurrentRegion
- For i = 1 To UBound(arr)
- d(arr(i, 1)) = ""
- Next
- s2 = 1: s = 1
- For i = 1 To UBound(brr)
- d2(brr(i, 1)) = ""
- If Not d.exists(brr(i, 1)) Then s2 = s2 + 1: Sheet2.Cells(s2, 3) = brr(i, 1)
- Next
- For i = 1 To UBound(arr)
- If Not d2.exists(arr(i, 1)) Then s = s + 1: Sheet2.Cells(s, 1) = arr(i, 1)
- Next
- End Sub
复制代码 |
|