View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default looking for fractions

A helper column with the formula

=mod(a1,1)

dragged down

then filter this and your data column for 0

Mike

"Rosa59" wrote:

I have a huge table in which I want to want to filter one of the columns
according values that are not an integer. (i.e. 3.7 boxes, 2.4 boxes, etc.)
What formula or function can I use? I DO NOT WANT TO CHANGE THE VALUE TO AN
INTEGER.
Thanks
Rosa