| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Autofilter to filter out non-numeric rows
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" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Autofilter to filter out non-numeric rows
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" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Autofilter to filter out non-numeric rows
Try selecting custom with "does not equal": "*"
|
| Reply |
| 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) | |||
Linear Mode
