Macro or IF statement - HELP!

J

Julia Easter

Hi - I've got a stack of customer data that's been
extracted from a database in CSV format and then opened in
Excel

All's well apart from some of the accounts I dont need -
these are one's that have no deatils in the "Bank" "Sort
Code" "Account" columns.

My question is how do I go about getting Excel to look at
the blanks and automatically Delete them?

So far my little knowledge allowed me to make the
following if statement but it only tells me to
physically "DELETE" non-bank customers... I want to know
how I get to tell Excel to actually search for bloanks
then delete.... if that makes sence!!

HELP
Ta
Julia
 
J

JMay

Create a Helper (New) Column:
and enter =AND(ISBLANK(B5),ISBLANK(D5),ISBLANK(F5))
and copy down (change cell references of mine to yours,)
this will get you either TRUE or FALSE;
Then do an Auto-Filter - Select TRUE Only and Delete All
HTH
 
Top