|
发表于 2013-5-6 22:53
|
显示全部楼层
本楼为最佳答案
- Sub 条件()
- Dim ar, br, cr, dr(1 To 5000, 1 To 1)
- Dim i, j, L1, L2, L3, M, n, k, o
- Dim d As Object
- Set d = CreateObject("scripting.dictionary")
- o = 4
- For k = 10 To 16 Step 3
- ar = Range("E" & k & ":J" & k + 2)
- ar = Range("e10:j12")
- For j = 1 To UBound(ar, 2)
- For L1 = 1 To Len(ar(1, j))
- For L2 = 1 To Len(ar(2, j))
- For L3 = 1 To Len(ar(3, j))
- M = ""
- M = Mid(ar(1, j), L1, 1) & Mid(ar(2, j), L2, 1) & Mid(ar(3, j), L3, 1)
- d(M) = d(M) + 1
- Next L3
- Next L2
- Next L1
- Next j
- br = d.keys
- cr = d.Items
- n = 0
- For i = 0 To UBound(cr)
- If cr(i) > 2 Then
- n = n + 1
- dr(n, 1) = br(i)
- End If
- Next
- o = Cells(Rows.Count, 1).End(xlUp).Row + 1
- Range("A" & o).Resize(n, 1) = dr
- d.RemoveAll
- Next
- End Sub
复制代码 |
|