View Single Post
Old 29-08-2007, 15:32   #3
Aragorn
Inactive
 
Aragorn's Avatar
 
Join Date: Apr 2004
Location: Minas Tirith, Gondor
Age: 60
Posts: 3,458
Aragorn has a nice shiny star
Aragorn has a nice shiny starAragorn has a nice shiny starAragorn has a nice shiny starAragorn has a nice shiny starAragorn has a nice shiny starAragorn has a nice shiny starAragorn has a nice shiny starAragorn has a nice shiny starAragorn has a nice shiny starAragorn has a nice shiny starAragorn has a nice shiny starAragorn has a nice shiny star
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 = " ";
Aragorn is offline   Reply With Quote