Delete rows with certain columns blank

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My spreadsheet has this format:

A B C D E
a b x
a b x x
a b
a b x

What I am need to do is delete all rows where columns C,D & E are blank. In
the illustration above row 3 would be deleted.
Can anyone help?

Thanks
Slohcin
 
I'd insert a new column F and put this formula in F1:
=counta(C1:E1)
and drag down

Then I could apply data|Filter|autofilter to show only the 0's and delete those
visible rows.

Then remove the filter and delete that helper column.
 
Hi Slohcin

The easiest way (without and code) would be to apply the autofilter to your
data and filter non-blanks on columns C,D & E.

HTH

Simon
 
Back
Top