Sub TEST()
For I = Range("F65536").End(3).Row To 3 Step -1
For J = 3 To Range("E65536").End(3).Row
If Cells(I, "F") = Cells(J, "E") Then GoTo 10
Next
Cells(I, "F").Delete Shift:=xlUp
10 Next
End Sub
Sub TEST2()
On Error Resume Next
For I = Range("F65536").End(3).Row To 3 Step -1
Set S = Range("E:E").Find(Cells(I, "F"))
If S Is Nothing Then Cells(I, "F").Delete Shift:=xlUp
Next
End Sub