|
Sub demo()
Dim ar, br(1 To 300000, 1 To 1), i, j
Set d = CreateObject("scripting.dictionary")
ar = [b3:k1000]
For i = 1 To UBound(ar)
For j = 1 To 10
If ar(i, j) <> 0 Then
If Not d.Exists(ar(i, j)) Then
n = n + 1
br(n, 1) = "'" & Format(ar(i, j), "000")
End If
End If
Next
Next
Range("q3").Resize(n, 1) = br
Range("q3").Resize(n, 1).Sort Range("q3"), xlAscending, Header:=xlNo
End Sub
|
评分
-
查看全部评分
|