|
发表于 2014-2-8 10:56
|
显示全部楼层
本楼为最佳答案
本帖最后由 CheryBTL 于 2014-2-8 10:58 编辑
GYUHJ 发表于 2014-2-8 10:34
1,从N列开始,每连续7列的1,3,5,7这4列如果都有相同数,并且这个相同数在(1,3,5,7)每列刚好重复个数都是5个 ...
请测试:- Sub test()
- Dim ar, re, temp
- Dim i As Integer, j As Integer, Cnt As Integer
- Dim b As Boolean
- ar = Sheets(1).Range("N3").CurrentRegion
- ReDim re(1 To 9999, 1 To 1)
- For i = 1 To UBound(ar, 2) - 6
- ReDim temp(3, 999)
- For j = 1 To UBound(ar)
- For k = 0 To 3
- If ar(j, i + k * 2) <> "" Then
- temp(k, Val(ar(j, i + k * 2))) = temp(k, Val(ar(j, i + k * 2))) + 1
- End If
- Next
- Next
- For j = 0 To 999
- b = True
- For k = 0 To 3
- If temp(k, j) <> 5 Then b = False: Exit For
- Next
- If b 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
复制代码 |
|