View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kim[_3_] Kim[_3_] is offline
external usenet poster
 
Posts: 7
Default Filter cells with non-whole numbers or comment

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