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, 2, 5, 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
arr = Range("a1:f" & Range("a65536").End(xlUp).Row)
ReDim brr(1 To UBound(arr), 1 To 1)
w = Array(1, 3, 6, 7)
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("i1").Resize(UBound(brr)) = brr
End Sub
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, 2, 5, 8)
w = Array(1, 3, 6, 7)
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
Range("i1").Resize(UBound(brr)) = brr
End Sub