Select column C and F5SpecialBlanksOK

EditDeleteEntire Row


Gord Dibben MS Excel MVP

On Fri, 7 Dec 2007 08:27:07 -0800, 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!