自己修改吧:
Sub TEST()
Set D = CreateObject("scripting.dictionary") '设置字典
For Each RAN In Range("A1:C10") '可修改为你的区域
D(RAN.Value) = ""
Next
Range("E1").Resize(D.Count) = Application.Transpose(D.KEYS) '获得不重复值
End Sub
自己修改吧:
Sub TEST()
Set D = CreateObject("scripting.dictionary") '设置字典
For Each RAN In Range("A1:C10") '可修改为你的区域
D(RAN.Value) = ""
Next
Range("E1").Resize(D.Count) = Application.Transpose(D.KEYS) '获得不重复值
End Sub