Posted to microsoft.public.excel.worksheet.functions
|
|
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!
|