|
发表于 2015-2-27 20:42
|
显示全部楼层
本楼为最佳答案
本帖最后由 dsmch 于 2015-2-27 20:45 编辑
- Sub Macro1()
- Dim arr, brr, w(9), i&, n%, j%, j2%, j3%, s%
- [g:g] = ""
- arr = Range("a2").CurrentRegion
- ReDim brr(1 To UBound(arr), 1 To 1)
- n = UBound(arr, 2)
- For i = 1 To UBound(arr)
- s = 0
- For j = 1 To n - 3
- For j2 = j + 1 To n - 2
- For j3 = j2 + 1 To n - 1
- For j4 = j3 + 1 To n
- zf = arr(i, j) & arr(i, j2) & arr(i, j3) & arr(i, j4)
- For k = 1 To 12
- z = Mid$(zf, k, 1)
- w(z) = z
- Next
- If Len(Join(w, "")) >= 8 Then s = s + 1 '不重复个数8
- Erase w
- Next
- Next
- Next
- Next
- If s =15 Then brr(i, 1) = "符合" '符合条件的组合个数
- Next
- Range("g2").Resize(UBound(brr)) = brr
- End Sub
复制代码 |
|