Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
How do filter cells so only those not a whole number (like .5, .123, .
85) or a comment returns ? This is in the same column, but if possible would I like it to apply to multiple columns (I think advanced filter is needed). Also if the comment part can not be done, then the number will do. Data 11.5 11 10 7.85 4 (has comment) (Advanced) Filter should return 11.5 7.85 4 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
EXCEL FILTER OF COMMENT CONTENT | Excel Discussion (Misc queries) | |||
Copy only visible cells after filter is applied/ sum after filter | Excel Worksheet Functions | |||
How do I use advanced filter to filter for blank cells? | Excel Discussion (Misc queries) | |||
Comment indicators show as numbers in HTML | Excel Discussion (Misc queries) | |||
Comment position after filter | Excel Discussion (Misc queries) |