Delete rows with certain columns blank

S

Slohcin

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
 
D

Dave Peterson

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.
 
S

smw226 via OfficeKB.com

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
 
Top