| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to determine the minimum difference between values?
Does anyone have any suggestions on how to determine the minimum difference
between values? There is a list of value under column A 307, 325, 343, 361, 381, 401, 421, 441 and there is a given value 400 in cell B1, I would like to determine the minimum difference between 400 and the list of values, and it should return 1 in cell C1, because abs(400-401) = 1. Does anyone have any suggestions on how to do it in Excel? Thanks in advance for any suggestions Eric |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to distribute coins to achieve minimum difference? | Excel Discussion (Misc queries) | |||
| How to determine the minimum value with given condition? | Excel Discussion (Misc queries) | |||
| Sum of minimum values in a Range. | Excel Discussion (Misc queries) | |||
| How to determine the minimum value? | Excel Discussion (Misc queries) | |||
| Can you compare similar spreadsheets to determine a difference? | Excel Discussion (Misc queries) | |||
Threaded Mode
