| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Function for max of percentage or dollar amount | Excel Worksheet Functions | |||
| Function to Convert dollar to text? | Excel Worksheet Functions | |||
| Dollar signs | New Users to Excel | |||
| dollar sign | Excel Discussion (Misc queries) | |||
| dollar figure to text function | Excel Worksheet Functions | |||
Hybrid Mode
