|
最简单的方法,列出所有组合,一个个去校验代码如下:
Sub peng()
rw = Range("a65536").End(3).Row
ar = Range("e11:t" & rw)
ReDim br(1 To UBound(ar), 1 To 2)
Dim cr(1 To 100000, 1 To 2)
For i = 1 To UBound(ar)
For j = 1 To UBound(ar, 2)
If ar(i, j) <> "" Then
br(i, 1) = i: br(i, 2) = j
Exit For
End If
Next
Next
For a = 1 To UBound(ar) - 9
For b = a + 1 To a + 7
For c = b + 1 To a + 8
For d = c + 1 To a + 9
If a - b = c - d And br(a, 2) - br(c, 2) = br(b, 2) - br(d, 2) Then
n = n + 1
cr(n, 1) = br(a, 2) & "|" & br(b, 2) & "|" & br(c, 2) & "|" & br(d, 2)
cr(n, 2) = a & "|" & b & "|" & c & "|" & d
End If
Next
Next
Next
Next
Cells(11, 23).Resize(n, 2) = cr
End Sub |
评分
-
查看全部评分
|