Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Autofilter to filter out non-numeric rows

4,928 views
Skip to first unread message

ashish128

unread,
Feb 7, 2008, 8:09:45 AM2/7/08
to
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

@consumerdotorg Bernie Deitrick

unread,
Feb 7, 2008, 9:04:08 AM2/7/08
to
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" <ashi...@gmail.com> wrote in message
news:58b9db13-58bb-4bee...@i72g2000hsd.googlegroups.com...

MartinW

unread,
Feb 7, 2008, 9:28:01 AM2/7/08
to
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" <ashi...@gmail.com> wrote in message
news:58b9db13-58bb-4bee...@i72g2000hsd.googlegroups.com...

Parag Agrawal

unread,
Jan 15, 2023, 10:00:52 PM1/15/23
to
=FILTER(A1:C10,ISERROR(VALUE(A1:A)))

Bayram Can

unread,
Jan 22, 2023, 12:22:27 PM1/22/23
to
Bayan escortlar ile görüşmek için ey iyi site olan Denizli escort sitesinin adresini buradan veriyoruz.
Site: https://www.aradene.com
0 new messages