如题所述
Sub zidian()
Dim d, r, ar, i
Set d = CreateObject("scripting.dictionary")
r = Sheet1.Cells(Rows.Count, 1).End(xlUp).Row
ar = Range("a2:a" & r)
For i = 1 To UBound(ar)
d(ar(i, 1)) = ""
Next
[c2].Resize(d.Count, 1) = Application.Transpose(d.keys)
Set d = Nothing
End Sub追问
Dim d, r, ar, i
Set d = CreateObject("scripting.dictionary")
r = Sheet1.Cells(Rows.Count, 1).End(xlUp).Row
ar = Range("a2:a" & r)
For i = 1 To UBound(ar)
d(ar(i, 1)) = ""
Next
[c2].Resize(d.Count, 1) = Application.Transpose(d.keys)
Set d = Nothing
End Sub追问
我是从csv中读取数据 日期 有重复 新建的报表 sheet页是按日期建的 日期重复了 新建sheet建不了
温馨提示:答案为网友推荐,仅供参考
第1个回答 2013-05-21
用字典百度一下:
Vba使用字典提取不重复数据追问
Vba使用字典提取不重复数据追问
z最后两条重复 该如何做
没看到你的代码,不好解决。
本回答被提问者采纳