| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return 2nd Lowest Value Q
The formula below returns the the name associated with the lowest
value in a range. How would I tweak this formula to return the 2nd lowest value? INDEX(A8:A34,MATCH(MIN(G8:G34),G8:G34,0)) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I need to return the lowest time value in a range of cells. | Excel Worksheet Functions | |||
| Formula to return lowest value of 3 datapoints | Excel Worksheet Functions | |||
| Execl formula return the lowest value | Excel Worksheet Functions | |||
| Match 3 Criteria and Return Lowest Numeric Value | Excel Worksheet Functions | |||
| Return lowest quantity | Excel Worksheet Functions | |||
Threaded Mode
