| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Filter out Non-Number (i.e. Text) Cells
Add helper column and enter =ISNUMBER(A1) - copy down
All numbers should return TRUE, Text = FALSE "ashish128" wrote: 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Filter out Non-Number (i.e. Text) Cells
On Feb 7, 6:19*pm, Jim May wrote:
Add helper column and enter *=ISNUMBER(A1) - copy down All numbers should return TRUE, Text = FALSE "ashish128" wrote: 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- Hide quoted text - - Show quoted text - Hi Jim, Thanks for the quick response. I have now understood the solution and will work on it. Thanks again |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Filter out Non-Number (i.e. Text) Cells
Apply a custom filter of greater then equal 0 to filter out text
"ashish128" wrote: 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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Filter out Non-Number (i.e. Text) Cells
On Feb 7, 6:20*pm, Mike H wrote:
Apply a custom filter of greater then equal 0 to filter out text "ashish128" wrote: 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- Hide quoted text - - Show quoted text - Hi, Mike, Thank you. I got the point. Thanks again. |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Filter out Non-Number (i.e. Text) Cells
Insert a column next to the data you want to use the data filter and on the
new column key this: =IsNumberyoursourcecolumn) it should return true or false and then set the filter on this column and select TRUE. -- If this posting was helpful, please click on the Yes button. Regards, Michael Arch. "ashish128" wrote: 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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Filter out Non-Number (i.e. Text) Cells
On Feb 7, 6:24*pm, Michael wrote:
Insert a column next to the data you want to use the data filter and on the new column key this: =IsNumberyoursourcecolumn) it should return true or false and then set the filter on this column and select TRUE. -- If this posting was helpful, please click on the Yes button. Regards, Michael Arch. "ashish128" wrote: 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- Hide quoted text - - Show quoted text - Thank you Michael. Thanks for the help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Some cells contain # and text, some # only - want to sum # (number | Excel Discussion (Misc queries) | |||
| Filter on more than one cells (text) | Excel Worksheet Functions | |||
| Excel Changes Text Cells to Number Cells When Importing XML | Excel Discussion (Misc queries) | |||
| number of cells containing text | Excel Discussion (Misc queries) | |||
| How to set a number number value as text in all cells ? | Excel Worksheet Functions | |||
Hybrid Mode
