|
发表于 2016-7-7 09:52
|
显示全部楼层
本楼为最佳答案
Sub Macro1()
Dim arr, brr, i&, j%, k%
arr = Range("a1:f" & Range("a65536").End(xlUp).Row)
ReDim brr(1 To UBound(arr), 1 To 1)
w = Array(1, 3, 6, 8)
For i = 2 To UBound(arr)
s = 0
For j = 1 To UBound(arr, 2)
For k = 0 To UBound(w)
If arr(i, j) = w(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("h1").Resize(UBound(brr)) = brr
End Sub
|
|