| Home |
| Search |
| Today's Posts |
|
#5
|
|||
|
|||
And toss that de-caf stuff! <vbg
Duke Carey wrote: No, Dave. You gave me too much credit. I was writing the formula in the reply, on the fly, and forgot to put the MAX() function in. Somedays you just gotta drink 2 cups of coffee before giving advice. "Dave Peterson" wrote: I'm betting you put =max(b2:b10) in D2. But you could have just used that in your formula: =INDEX(A2:A10,MATCH(max(b2:b10),B2:B10,0)) Duke Carey wrote: Assuming the data is in cells A2:B10, use the formula =INDEX(A2:A10,MATCH(D2,B2:B10,0)) "Fishbone" wrote: I have a list with value_name and its value. Is there a formula that can look down the list and pick the highest value and return the value_name For example _Value_Name_ _Value_ Value A 5 Value B 10 Value C 33 Value D 8 Value E 51 Value F 32 Value G 47 Value H 9 Value I 41 So the formula would return Value E as its result. Would be much appreciated :) -- Fishbone ------------------------------------------------------------------------ Fishbone's Profile: http://www.excelforum.com/member.php...o&userid=11848 View this thread: http://www.excelforum.com/showthread...hreadid=395276 -- Dave Peterson -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selecting the 2nd highest value in a row. | Excel Worksheet Functions | |||
| 3 highest values | New Users to Excel | |||
| Highest Value / Circular Reference Help | Excel Discussion (Misc queries) | |||
| Highest Value / Circular Reference Help | Excel Worksheet Functions | |||
| In Excel, I need to now how to pick the second highest number in . | Excel Worksheet Functions | |||
Threaded Mode
