| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compare number to range; find highest positive difference
I need to compare the value in a cell to a range of values, and select the
value in the range that has the smallest positive difference. If the index cell is 4, and the range has 1,2,3 and 9, I need the range to pick 9. I've tried to use =min(index no. - range), but that doesn't seem to work; vlookup doesn't seem to work, either. Grateful for your thoughts. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare two columns and find the difference between the two column | Excel Discussion (Misc queries) | |||
| Find closest match and return next highest number in range | Excel Discussion (Misc queries) | |||
| An add-in that allows you to find the highest prime in a number | Excel Discussion (Misc queries) | |||
| Find Median of Positive numbers only in Range | Excel Worksheet Functions | |||
| How do I compare 2 worksheets, 1 old, 1 updated to find difference | Excel Discussion (Misc queries) | |||
Threaded Mode
