deleting rows ?macro

[anand kumar]

I have a database I'm developing (list of subjects) with
about 3000 names in the first column A. Column B and C
(and additional columns) have the key data. However, I've
only entered about 1000 or so subjects (randomly among the
3000). I'd like to do a preliminary analysis but must
create a continuous data array in which all the rows that
have names but no data are eliminated.

Is there a way to use the IF function to delete all rows
that have a blank in place of numeric data in a specific
column (thus compressing the 3000 rows to about 1000).

Would appreciate any advice.

Thanks

anand kumar

 

[Marty]

If this is a one time deal, and the way you phrase it it
is, then a macro is not the way to go. You can achieve
what you ask by selecting all the columns with data. Then
click Data > Filter > Auto Filter. Now click the down
arrow on the column with the blank data; select Blank.
Highlight all the rows it selected, right click in the
highlighted and click delete.

Marty

 

[Guest]

Or just filter the list by clicking Nonblanks to show the data that is not blank.