K
Kim
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
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