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

I don't fully understand what it is that you are trying to do but would a
'helper' column of =INT(A1) etc. then filter on that helper column do what
you want?

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Rosa59" wrote in message
...
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

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

EXCELLENT! I had to look up the meaning of that function, but now I've got
it. Thanks so much.
Rosa

"Mike H" wrote:

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