Filter out Non-Number (i.e. Text) Cells

[ashish128]

Hi all,

Greetings,

Could you please tell me if it is possible to filter out a range by
removing that rows in which the cell value is a text and not number.

Say,

1. Autofilter on Range A1 to C10
2. Select Criteria on Column A (Cell A1) to show only those rows which
contain numbers.

I tried Autofilter but there was no such option (Select only Numbers).

Please help.

Regards

Ashish Sharma

 

[Jim May]

Add helper column and enter =ISNUMBER(A1) - copy down
All numbers should return TRUE, Text = FALSE

 

[Mike H]

Apply a custom filter of greater then equal 0 to filter out text

 

[Michael]

Insert a column next to the data you want to use the data filter and on the
new column key this:

=IsNumberyoursourcecolumn)
it should return true or false and then set the filter on this column and
select TRUE.

 

[ashish128]

Insert a column next to the data you want to use the data filter and on the
new column key this:

=IsNumberyoursourcecolumn)
it should return true or false and then set the filter on this column and
select TRUE.

--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.







- Show quoted text -

Thank you Michael.

Thanks for the help.

 

[ashish128]

Apply a custom filter of greater then equal 0 to filter out text







- Show quoted text -

Hi, Mike,

Thank you. I got the point.

Thanks again.

 

[ashish128]

Add helper column and enter  =ISNUMBER(A1) - copy down
All numbers should return TRUE, Text = FALSE







- Show quoted text -

Hi Jim,

Thanks for the quick response.

I have now understood the solution and will work on it.

Thanks again