Autofilter to filter out non-numeric rows

[ashish128]

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

 

[Bernie Deitrick]

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

 

[MartinW]

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

 

[Lori]

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