Sub Test() Dim Dic As Object, Itm Dim Arr, k% Set Dic = CreateObject("Scripting.Dictionary") Arr = Range("A1", [A65536].End(3)) For k = 1 To UBound(Arr) Dic(Arr(k, 1)) = Dic(Arr(k, 1)) + 1 Next
For Each Itm In Dic If Dic(Itm) = 1 Then Dic.Remove Itm Next
MsgBox "重复记录为: " & Join(Dic.keys, ",") Set Dic = Nothing End Sub
B1以下复制公式。
Dim Dic As Object, Itm
Dim Arr, k% Set Dic = CreateObject("Scripting.Dictionary")
Arr = Range("A1", [A65536].End(3))
For k = 1 To UBound(Arr)
Dic(Arr(k, 1)) = Dic(Arr(k, 1)) + 1
Next
For Each Itm In Dic
If Dic(Itm) = 1 Then Dic.Remove Itm
Next
MsgBox "重复记录为: " & Join(Dic.keys, ",")
Set Dic = Nothing
End Sub