|
发表于 2014-2-8 14:22
|
显示全部楼层
本楼为最佳答案
提取的数据有重复要不去重呢?
未去重的数据,请测试:- Sub test()
- Dim ar, re, temp
- Dim i As Integer, j As Long, Cnt As Long
- ar = Sheets(1).Range("N3").CurrentRegion
- ReDim re(1 To 9999, 1 To 1)
- For i = 1 To UBound(ar, 2) - 3
- ReDim temp(999) As Integer
- For j = 1 To UBound(ar) - 3
- For k = 0 To 3
- If ar(j, i + k) <> "" Then
- temp(Val(ar(j, i + k))) = temp(Val(ar(j, i + k))) + 1
- End If
- Next
- Next
- For j = 0 To 999
- If temp(j) > 20 Then
- Cnt = Cnt + 1
- re(Cnt, 1) = Format(j, "000")
- End If
- Next
- Next
- Sheets(1).[a1:a65536].ClearContents
- If Cnt > 0 Then
- Sheets(1).[a1].Resize(Cnt) = re
- Else
- MsgBox "无匹配数据"
- End If
- End Sub
复制代码 |
|