Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Closest Match Formula
Let me start with an example of data first...
12 25 2 9 ? I have 4 columns above. The first three columns are numbers and one of those needs go into a new column, which would be column 5. In column 5, I need to know which of the first three columns is the closest match to column 4 without going over. Can a formula be set up like this? This would be in Excel 2003. Thanks! Trisha |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help! Find Closest Coordinate Match | Excel Discussion (Misc queries) | |||
index and match closest | Excel Worksheet Functions | |||
closest match | Excel Worksheet Functions | |||
Finding Closest Match | Excel Worksheet Functions | |||
Closest number match help ... | Excel Worksheet Functions |