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
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...
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...