Dim zd
Set zd = CreateObject("scripting.dictionary") '创建字典
hs = 2 '写入行数,初始为第2行
For i = 6 To Worksheets("sheet2").[a1000000].End(3).Row '循环a列所有行
s = Worksheets("sheet2").Cells(i, 1)
If Not zd.exists(s) Then '字典不存在,表示不重复
Cells(hs, 2) = s '写入a列
zd(s) = i ‘写入字典,以备后续判断’
hs = hs + 1 'a列行数+1
End If
Next i
zd.RemoveAll '清除字典,以备H列的判断
hs = 2
For i = 6 To Worksheets("sheet2").[h1000000].End(3).Row
s = Worksheets("sheet2").Cells(i, 8)
If Not zd.exists(s) Then
Cells(hs, "i") = s
zd(s) = i
hs = hs + 1
End If
Next i