|
'输出到sheet2,满意来朵小花
Option Explicit
Sub test()
Dim i, arr, a, b, dic, n, brr
Set dic = CreateObject("scripting.dictionary")
With Sheets("sheet1")
a = .[a1048576].End(xlUp).Row
b = .[d1048576].End(xlUp).Row
arr = .Range("a2:d" & IIf(a > b, a, b))
End With
ReDim brr(1 To b, 1 To 1)
For i = 1 To a - 1: dic(arr(i, 1)) = vbNullString: Next
For i = 1 To b - 1
If Not dic.exists(arr(i, 4)) Then
n = n + 1: brr(n, 1) = arr(i, 4)
End If
Next
With Sheets("sheet2").[a:a]
.ClearContents
If n > 0 Then .Resize(n, 1) = brr
End With
End Sub |
评分
-
1
查看全部评分
-
|