Deleting Records based on criterion

[Bruce Roberson]

I know about advanced filters and filtering out records
based on a criterion.

But if I wanted to use the approach of deleting the
records that don't match a criterion, how would I go about
this in Excel?

I would rather not use a macro for this unless its the
only way.

Thanks,


Bruce

 

[Jim Rech]

After you do your Autofilter (or in-place Advanced Filter) only the rows to
be deleted will be visible. Select these rows (you only need to select one
column) and do an Edit, Delete Row. Click Ok to the confirming prompt.
Only the visible rows will be deleted (Excel is pretty smart<g>) just as you
wanted.