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.



Slohcin wrote:

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

--

Dave Peterson