Delete rows

  • Thread starter Thread starter peterrebsamen
  • Start date Start date
P

peterrebsamen

I have the following problem: In a column with the following 3 entries:
Cell A1 "CG Leimer Kurt PMU (02015)", Cell A2 "CG Vaz Pinto Gonçalo
(03187)", Cell A3 "CG PMU Insinger KS (60010)", I would like to
automatically delete all rows where in column A the letters PMU appear.
In other words, I would like excel to delete the first and the third
row. Since PMU does not appear in cell A2, I would like that excel
keeps this row. Any idea of an easy way to do this?
 
Peter,

Use Autofilter to select rows that contains PMU, and then just select the
visible rows and delete them. Then turn off Autofilter.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
One way:

Insert a new row1

Put in B2: =IF(ISERROR(SEARCH("PMU",A2)),"Yes","No")

Copy B2 down as many rows as there is data in col A

Do an Autofilter on row1, col B > select "No"

Delete the filtered rows (these are the ones you don't want)

Remove Autofilter
 
sorry max, did not get the chance to answer you yesterday. your wa
worked perfectly. thanks very much
 
Back
Top