Delete rows with certain columns blank
 

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

Delete rows with certain columns blank
 

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

Delete rows with certain columns blank
 

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



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

--
--------------------
Simon - UK

Email at simon22mports [ a t ] hot mail [ d ot ]com

Message posted via http://www.officekb.com