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