For the non integers you can use an auxiliary column with the formula:

=MOD(A2,1)<0

You can then filter on TRUE.

I don;t know of a way to identify comments in a cell other than VBA.
You can define the following function

Function HasComment(r as Range)
HasComment = IsNull(r.comment)
End Function

You can then use another auxiliary column with the formula:

=HASCOMMENT(A2)

And again filter on TRUE/FALSE

HTH
Kostis Vezerides

On Nov 16, 1:24*pm, Kim wrote:
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