On Thursday, February 7, 2008 at 6:39:45 PM UTC+5:30, ashish128 wrote:
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)))
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)