| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Excel Macro
I have 7000x2 matrix of data. Some have decimal value and some don't.
I just want to pick or sort out the ones WITHOUT decimals. Should I write a macro for this and How? |
|
#2
|
|||
|
|||
|
You could write code, but don't necessarily have to. You can use this
formula to find all the decimal point in the adjacent cell; it returns TRUE when the decimal is found and FALSE when it is not. Then sort the spreadsheet using the TRUE/FALSE column. =IF(ISNUMBER(FIND(".",A1,1)),TRUE,FALSE) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| passing arguments from an excel macro to a word macro | Excel Discussion (Misc queries) | |||
| Excel macro that opens new MS Word file and pastes data as a pictu | Excel Worksheet Functions | |||
| Can't find macro in an Excel file to delete it | Excel Discussion (Misc queries) | |||
| Saving Excel using Macro | Excel Discussion (Misc queries) | |||
| Problem Editing Macro in Shared Excel File | Excel Discussion (Misc queries) | |||
Linear Mode
