| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autofilter to filter out non-numeric rows
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I filter for a blank cell, using custom autofilter | Excel Discussion (Misc queries) | |||
| saving autofiltercustom filter settings | Excel Worksheet Functions | |||
| Excel 2002 - Is it possible to use Data,Filter,Autofilter as X-Axi | Charts and Charting in Excel | |||
| Product Price List with 14k records, filter w/out using AutoFilter | Excel Worksheet Functions | |||
| Shortcut for Filter- Custom Autofilter | Excel Discussion (Misc queries) | |||
Threaded Mode
