|
- Sub 提取()
- Dim i, j, k, l As Byte
- Dim d As Object
- Set d = CreateObject("scripting.dictionary")
- Dim ar, br()
- ar = Range("a2:e" & Range("e65536").End(xlUp).Row)
- ReDim br(1 To UBound(ar), 1 To 10)
- For i = 1 To UBound(ar)
- For k = 1 To 5
- d(Val(ar(i, k))) = ""
- Next
- For j = 0 To 9
- If Not d.exists(j) Then
- l = l + 1
- br(i, l) = j
- End If
- Next
- l = 0
- d.RemoveAll
- Next
- Range("g2").Resize(UBound(ar), 10).ClearContents
- Range("g2").Resize(UBound(ar), 10) = br
- End Sub
复制代码
没出现过的数字的自定义函数.rar
(10.09 KB, 下载次数: 4)
|
|