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

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

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

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

"ashish128" wrote:

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

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

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

"ashish128" wrote:

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

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

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.




"ashish128" wrote:

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

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

On Feb 7, 6:24*pm, Michael wrote:
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.



"ashish128" wrote:
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- Hide quoted text -

- Show quoted text -

Thank you Michael.

Thanks for the help.

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

On Feb 7, 6:20*pm, Mike H wrote:
Apply a custom filter of greater then equal 0 to filter out text



"ashish128" wrote:
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- Hide quoted text -

- Show quoted text -

Hi, Mike,

Thank you. I got the point.

Thanks again.

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

On Feb 7, 6:19*pm, Jim May wrote:
Add helper column and enter *=ISNUMBER(A1) - copy down
All numbers should return TRUE, Text = FALSE



"ashish128" wrote:
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- Hide quoted text -

- Show quoted text -

Hi Jim,

Thanks for the quick response.

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

Thanks again