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

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

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