Sub Click()
Dim A, i, j, x, v1, v2, b1, b2
i = Range("a65536").End(3).Row
Range("c2:c" & i).ClearContents
A = Range("a1:c" & i)
j = 1
For i = UBound(A) To 2 Step -1
x = A(i, 2)
b1 = x Like "*a*" And x Like "*c*"
b2 = x Like "*b*" And x Like "*f*"
If b1 Then v1 = x '条件1
If i Mod 2 = 0 Then If b2 Then v2 = x '条件2
If b1 = False And b2 = False Then j = j + 1: A(j, 3) = x '条件3
Next i
[k1].CurrentRegion.ClearContents
[k1].Resize(UBound(A), UBound(A, 2)) = A
Cells(Range("m65536").End(3).Row + 1, "m") = v2
Cells(Range("m65536").End(3).Row + 1, "m") = v1
End Sub
这样可以吗