|
发表于 2016-9-24 23:31
|
显示全部楼层
本楼为最佳答案
Sub tt()
Dim arr, i%
Dim dic As Object
Range("b3:b65536").ClearContents
arr = Range("p9:p" & [p9].End(xlDown).Row)
Set dic = CreateObject("scripting.dictionary")
For i = 1 To UBound(arr)
If Left(arr(i, 1), 3) = "XS-" Then
If Not dic.Exists(arr(i, 1)) Then
dic(arr(i, 1)) = arr(i, 1)
End If
End If
Next i
Range("b3").Resize(dic.Count, 1) = Application.Transpose(dic.keys)
Set dic = Nothing
End Sub |
评分
-
查看全部评分
|