View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Slohcin Slohcin is offline
external usenet poster
 
Posts: 10
Default 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