|
模拟了一组(G--BN)列,结果显示在x列。
好象和原结果不一致。
- Sub 提取()
- arr = Sheets(1).[g1].CurrentRegion
- Set d = CreateObject("scripting.dictionary")
- Set d1 = CreateObject("scripting.dictionary")
- Dim brr(0 To 999) 'brr(x):数字x出现的列数
- For j = 1 To 60
- For i = 1 To UBound(arr)
- x = arr(i, j)
- If Len(x) > 0 Then
- If Not d.exists(x) Then
- d(x) = 1
- brr(Val(x)) = brr(Val(x)) + 1
- End If
- End If
- Next
- d.RemoveAll
- Next
- For i = 0 To 999 'd1(x):x列出现的所有数字
- If Len(brr(i)) Then d1(brr(i)) = d1(brr(i)) & "," & Format(i, "000")
- Next
- crr = Sheets(1).Range("d1:d" & [d65536].End(3).Row)
- For i = 1 To UBound(crr)
- If Len(crr(i, 1)) Then s = s & d1(crr(i, 1))
- Next
-
- xrr = Split(Mid(s, 2), ",")
- With Sheets(2)
- [x:x].ClearContents
- .[x1].Resize(UBound(xrr) + 1) = Application.Transpose(xrr)
- .Activate
- End With
- End Sub
复制代码 |
|