Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find the closest value
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find the closest value
Hello Tim,
Are you sure that you use the suggested formula? I used =INDEX(D1:D50,MATCH(MIN(ABS(C1:C50-A1)),ABS(C1:C50-A1),)) (as array formula!) and it worked. Regards, Volker |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find number closest to 0 | Excel Discussion (Misc queries) | |||
Array Lookup to Find Closest Date and Next Closest Date | Excel Worksheet Functions | |||
Find closest value | Excel Programming | |||
How do I find a column entry closest to a particular value | Excel Worksheet Functions | |||
How do I find a column entry closest to a particular value | Excel Discussion (Misc queries) |