|
- Sub demo()
- Dim arr, brr, re(), i, j, m, n
- arr = Range("a2:b" & Cells(Rows.Count, 1).End(3).Row).Value
- brr = Range("i2:i" & Cells(Rows.Count, 9).End(3).Row).Value
- ReDim re(1 To UBound(arr), 1 To 2)
- For i = 1 To UBound(arr)
- n = 0
- For j = 1 To UBound(brr)
- If arr(i, 1) = brr(j, 1) Then n = n + 1
- Next
- If n < 1 Then
- m = m + 1
- re(m, 1) = arr(i, 1)
- re(m, 2) = arr(i, 2)
- End If
- Next
- Range("e2:e65536").ClearContents
- Range("E2").Resize(m, 2) = re
- End Sub
复制代码 |
|