Whole Dollar Function
 

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!

Whole Dollar Function
 

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.

In article ,
Adam wrote:

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!

Whole Dollar Function
 

That worked perfectly!

"JE McGimpsey" wrote:

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.

In article ,
Adam wrote:

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!