View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default Delete row if blank in a column

AutoFilter, find blanks. then delete those rows.
--
Best Regards,

Luke M


"Outlook, eh?" wrote:

I was wondering what function I should use if one of the columns has a blank
in it.
In this case I want to get rid of the Ringo row (Go Figure).

A B C
Paul Yes
Ringo

John
Yes
George
Yes

Thanks as always. You have saved my neck many times!