|
怎么个相邻法?
A
B
C
D
E
F
G
H
请问D相邻的4个,是不是 A B C D E F G,上三,下三,这个地方没有说清楚。
不重复的3个数组合一共是4060组,代码如下,你其他要求再遍历判断提取就可以了:
Dim arr1(1 To 200000, 1 To 1)
Dim k As Integer
Sub 递归数组()
k = 0
Erase arr1
Dim arr
arr = Range("a1:a30")
zuhe arr, 1, "", 0
Range("b:b") = ""
Range("b1").Resize(k) = arr1
Dim arr2
arr2 = Range("b1:b" & k)
For i = 1 To k
If arr2(i, 1) Then
End If
Next i
End Sub
Sub zuhe(arr, x, sr As String, y)
If y = 3 Then
k = k + 1
arr1(k, 1) = sr
Exit Sub
End If
If x < UBound(arr, 1) + 1 Then
zuhe arr, x + 1, sr & arr(x, 1) & " ", y + 1
zuhe arr, x + 1, sr, y
End If
End Sub
|
|