Sub TEST()
Range("C2:C50").ClearContents
ARR = Range("B2:D" & Range("B65536").End(3).Row)
For I = UBound(ARR) To 1 Step -1
If ARR(I, 3) <> "" Then
K = 0
For J = 1 To Range("E2") + 2 '设定最多连续停产2天,若超过2天则修改
If ARR(I - J, 1) <> "停产" Then
K = K + 1
If K = Range("E2") Then ARR(I - J, 2) = ARR(I, 3): Exit For
End If
Next
End If
Next
Range("B2").Resize(UBound(ARR), 3) = ARR
End Sub
Sub TEST()
Range("C2:C50").ClearContents
ARR = Range("B2:D" & Range("B65536").End(3).Row)
For I = UBound(ARR) To 1 Step -1
If ARR(I, 3) <> "" Then
K = 0
For J = 1 To Range("E2") + 2 '设定最多连续停产2天,若超过2天则修改
If ARR(I - J, 1) <> "停产" Then
K = K + 1
If K = Range("E2") Then ARR(I - J, 2) = ARR(I, 3): Exit For
End If
Next
End If
Next
Range("B2").Resize(UBound(ARR), 3) = ARR
End Sub