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

Post by 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

[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

Post by 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

[Lori]

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

[Parag Agrawal]

Post by 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

=FILTER(A1:C10,ISERROR(VALUE(A1:A)))

[Bayram Can]

Bayan escortlar ile görüşmek için ey iyi site olan Denizli escort sitesinin adresini buradan veriyoruz.
Site: https://www.aradene.com