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!
|