| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
find similar numbers
Yes there is a formula:
If you have a column of numbers (say column A) and want to know which are "near" to others: 1. sort the column ascending 2. in B2 enter =ABS(A2-A1) and copy down Just by looking down column B you can find values that are close to each other. The correspond to very samll values of B -- Gary's Student "dune" wrote: How do I find similar or "near enough" numbers in a column. Is there a formula to show these numbers? ( not very well explained I suspect) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I find duplicate numbers within a column? | Excel Worksheet Functions | |||
| find sum in list of of numbers | Excel Discussion (Misc queries) | |||
| find closest match to a reference number in a row of numbers | Excel Discussion (Misc queries) | |||
| FIND FORMULA SIMILAR TO VLOOKUP FOR NON-ASCENDING VALUES | Excel Worksheet Functions | |||
| find same numbers in a list in Excel | Excel Discussion (Misc queries) | |||
Hybrid Mode
