|
- 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
- Range("j2").Offset(x).Resize(1, UBound(brr)) = Application.Transpose(brr)
- Next
- End Sub
复制代码 |
评分
-
查看全部评分
|