auto filter for number

G

Greg

Hello,
Is there a way to create a custom filter,
where a row is hidden if it does not contain any numbers?
If there is a number in a cell, then the row is not hidden?

thanks
 
G

Gord Dibben

Several methods I can think of.

1. In an adjacent column enter =ISNUMBER(A1) copy down column A.

Filter for TRUE

2. If using Excel 2007, select the range and Conditional Formatting>New
Rule>Use a formula

=NOT(ISNUMBER(A1)) format to a color.

Filter on "No Color"

3. VBA if you wanted to go that route.


Gord Dibben MS Excel MVP
 
G

Greg

thanks

Gord Dibben said:
Several methods I can think of.

1. In an adjacent column enter =ISNUMBER(A1) copy down column A.

Filter for TRUE

2. If using Excel 2007, select the range and Conditional Formatting>New
Rule>Use a formula

=NOT(ISNUMBER(A1)) format to a color.

Filter on "No Color"

3. VBA if you wanted to go that route.


Gord Dibben MS Excel MVP
Click to expand...
 
Top