auto filter for number

  • Thread starter Thread starter Greg
  • Start date Start date
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
 
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
 
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...
 
Back
Top