Public Sub www()
Dim i&, j&
For i = 1 To Cells(Rows.Count, 1).End(xlUp).Row
For j = 7 To 14
If Not IsError(Application.Match(Cells(i, j).Value, _
Range(Cells(i, 1), Cells(i, 5)).Value, 0)) Then Cells(i, j) = ""
Next
Next
End Sub
Или удалить:
Public Sub www()
Dim i&, j&
For i = 1 To Cells(Rows.Count, 1).End(xlUp).Row
For j = 7 To 14
If Not IsError(Application.Match(Cells(i, j).Value, _
Range(Cells(i, 1), Cells(i, 5)).Value, 0)) Then Cells(i, j) = Empty
Next
Range(Cells(i, 7), Cells(i, 15)).SpecialCells(4).Delete xlToLeft
Next
End Sub