View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ashish128 ashish128 is offline
external usenet poster
 
Posts: 48
Default Filter out Non-Number (i.e. Text) Cells

Hi all,

Greetings,

Could you please tell me if it is possible to filter out a range by
removing 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