Delete rows that do not contain specific text

can you attach a sample file ?

Hi,

Try this it may help.

Sub DeleteRows1()
  Dim i As Long
  Application.ScreenUpdating = False
  For i = Cells(Rows.Count, "C").End(xlUp).Row To 1 Step -1
    If Cells(i, "C").Value <> "missing" Then Cells(i, "C").EntireRow.Delete
  Next i
End Sub

David

Without VBA, to see only the rows that have "missing" somewhere on the row:

1) In AO1, put "Key"

2) In AO2 put this formula: =COUNTIF(A2:AN2, "Missing") > 0

3) Copy AO2 down the whole data set

4) Click Data > Filter to turn on the Autofilter

5) Click on AO1 and use the filter to see TRUE only


Done. The other rows are hidden, you can work with the "missing" rows and then turn off the autofilter when done.

I have marked this thread solved for you.
In the future please select Thread Tools from the menu above and mark the thread as solved. Thanks.