第4个回答 2011-01-15
用代码搞定
Sub test()
Dim d As Object, arr, brr()
Set d = CreateObject("scripting.dictionary")
arr = Range("A3:D3")
For i = 1 To UBound(arr, 2)
d(arr(1, i)) = ""
Next i
arr = Range("a2:h2")
For i = 1 To UBound(arr, 2)
If Not d.exists(arr(1, i)) Then
h = h + 1
ReDim Preserve brr(1 To h)
brr(h) = arr(1, i)
End If
Next i
[a5].Resize(1, UBound(brr)) = brr
Set d = Nothing
End Sub本回答被提问者采纳