Autofilter to filter out non-numeric rows
 

Hi all,

Greetings,

Could you please tell me if it is possible to filter out a range by
removing/ filtering 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

Autofilter to filter out non-numeric rows
 

Ashish,

Use a helper column, with the formula

=ISERROR(VALUE(A2))

Copied down.

This will return TRUE for strings, FALSE for numbers.

HTH,
Bernie
MS Excel MVP


"ashish128" wrote in message
...
Hi all,

Greetings,

Could you please tell me if it is possible to filter out a range by
removing/ filtering 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

Autofilter to filter out non-numeric rows
 

Hi Ashish,

You could put this in D1 and drag down to D10
=IF(ISTEXT(A1)+ISTEXT(B1)+ISTEXT(C1)0,1,0)

Then filter on D

HTH
Martin


"ashish128" wrote in message
...
Hi all,

Greetings,

Could you please tell me if it is possible to filter out a range by
removing/ filtering 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

Autofilter to filter out non-numeric rows
 

Try selecting custom with "does not equal": "*"