|
hanjia 发表于 2016-7-12 11:53
这些都不是目的啊
数据远不只这些,只能用分页才能完成
Sub Macro1()
Dim arr, brr, i&, j%, k%
arr = Range("a1:f" & [a65536].End(3).Row)
ReDim brr(1 To UBound(arr), 1 To 1)
arr1 = Array(1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12)
ReDim w(0 To 494)
For i = 0 To UBound(arr1) - 3
For j = 1 To UBound(arr1) - 2
If j > i Then
For k = 2 To UBound(arr1) - 1
If k > j Then
For l = 3 To UBound(arr1) - 0
If l > k Then
w(x) = Array(arr1(i), arr1(j), arr1(k), arr1(l))
x = x + 1
End If
Next
End If
Next
End If
Next
Next
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
For x = 0 To UBound(w)
For i = 2 To UBound(arr)
s = 0
For j = 1 To UBound(arr, 2)
For k = 0 To UBound(w(x))
If arr(i, j) = w(x)(k) Then s = s + 1
Next
If s >= 3 Then brr(i, 1) = 0: Exit For
Next
If s < 3 Then brr(i, 1) = brr(i - 1, 1) + 1
Next
If x <= 246 Then
Range("j2").Offset(0, x).Resize(UBound(brr)) = brr
ElseIf x >= 247 And x <= 493 Then
Sheet2.Range("j2").Offset(0, x - 247).Resize(UBound(brr)) = brr
Else
Sheet3.Range("j2").Offset(0, x - 493).Resize(UBound(brr)) = brr
End If
Next
End Sub
|
|