Whole Dollar Function

[Adam]

I have a download of data with varying amounts (ex. 20.00, 15.67, 20.15) and
I need to pull out all the amounts that are whole dollar amounts (integers).
What is the best way to approach this ?

Thank you for your help!

 

[JE McGimpsey]

Not sure what you mean by "pull out", so I don't know about "best", but
if you used a helper column, e.g.:

J1: =A1=INT(A1)

you could then Auto or Advanced filter on the TRUE/FALSEs in the helper
column.

 

[Adam]

That worked perfectly!

Not sure what you mean by "pull out", so I don't know about "best", but
if you used a helper column, e.g.:

J1: =A1=INT(A1)

you could then Auto or Advanced filter on the TRUE/FALSEs in the helper
column.