Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to determine the second large value from a list?
Does anyone have any suggestions on how to the second large value from a list?
The given number is within cell CM137, and the list is under CM138:CN240. =MIN(IF(CM137<CM138:CN240,CM138:CN240)), which work for max value, but =Small(IF(CM137<CM138:CN240,CM138:CN240),2) for the second large value, which does not work. Does anyone have any suggestions on how to do it in Excel? Thanks in advance for any suggestions Eric |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to determine the first 6 large numbers from a list? | Excel Discussion (Misc queries) | |||
Help with handling large amounts of data - determine "MIN IF" ? | Excel Worksheet Functions | |||
How to determine the value from a list? | Excel Discussion (Misc queries) | |||
How to determine the value from a list? | Excel Discussion (Misc queries) | |||
List ? - How do I make information in one cell determine list to u | Excel Worksheet Functions |