|
Re: excell deleting rows
You could add an extra calculated column, something like
if (A1<>" " and B2 <> " " and ..., "All fields present","not all there")
Sort by the new column and manually delete all the one saying 'All fields present'. (Sorry, I can't remember the exact if/and syntax!)
Alternatively use a database query to only select the interesting records, eg Select a, b ,c from table where a = " " or b = " " or c = " ";
|