| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to select no.'s in a column that differ by <1
aHi, could anyone tell me how to select numbers from a list/column that
differ from other numbers on the list by e.g. <1? Can I do this by inserting formula or would this involve programming? Any help would be extremely appreciated. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to select no.'s in a column that differ by <1
Let's say we have values in column A. First sort the column if it is not
already sorted ( or copy the column and sort elsewhere). Then select A2 and apply Conditional Formatting Formula is: =A2-A1<1 and copy the formatting down the column. This works because we are bringing close values close together -- Gary''s Student - gsnu200788 "Danni" wrote: aHi, could anyone tell me how to select numbers from a list/column that differ from other numbers on the list by e.g. <1? Can I do this by inserting formula or would this involve programming? Any help would be extremely appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Shortcut to select column with data in previous column | Excel Discussion (Misc queries) | |||
| Can the contents of a drop down box differ from what's entered? | Excel Worksheet Functions | |||
| select detail in column B if column A = date | Excel Worksheet Functions | |||
| powerpoint & excel how do they differ? | New Users to Excel | |||
| How can i set consecutive columns in an excel worksheet to differ. | Charts and Charting in Excel | |||
Hybrid Mode
