Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
deleting vs. filtering . . . HELP!
In a nutshell . . . A TEXT FILE IS IMPORTED . . .
In column C (example) there will either be text, a numeric value, or a "zero" (0). I need to set up a filter so that only rows with a numeric values 0 show. (No rows with text or a zero in C will show) I tried to set up a helper column that (example) would have a "yes" in column D if the cell (C1) had a plus value, and "no" if it had text or a zero. I used . . . =IF(C1<=0,"no","yes") Works OK to eliminate cells with a zero or negative number. There's a "no" in the next column. I figuresd I'd get a "yes" in the columns with only text. BUT NO! If there's text in the column, other than the number 0, it counts as a numeric value. So I get a "yes" in any row with text or a value greater than zero. 0 enters a no (good!) a negative number enters a no (Yazza!) a positive number enters a yes (poifec!) any text enters a yes (NO!) Hmmm. Comments welcome. :) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advance filtering with multiple conditons | Excel Discussion (Misc queries) | |||
deleting values in a worksheet without deleting the formulas | Excel Worksheet Functions | |||
how prevent formula in cell from deleting when deleting value???? | New Users to Excel | |||
Row filtering based on input box entry (column heading) | Excel Worksheet Functions | |||
trouble filtering a list. Why isn't column filtering? | Excel Worksheet Functions |