| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to determine the second large value from a list?
Try this...
=LARGE(CM138:CN240,2) where the 2 indicates second largest. -- Rick (MVP - Excel) "Eric" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to determine the second large value from a list?
Thank you very much for suggestions
I have applied a condition for determining the max one MIN(IF(CM137<CM138:CN240,CM138:CN240)), so I still want to apply this IF condition for the second one. Do you have any suggestions? Thanks in advance for any suggestions Eric "Rick Rothstein" wrote: Try this... =LARGE(CM138:CN240,2) where the 2 indicates second largest. -- Rick (MVP - Excel) "Eric" wrote in message ... 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 |
| Reply |
| 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 | |||
Linear Mode
