auto filter for number

[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

 

[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

 

[Greg]

thanks

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