How to determine the second large value from a list?

E

Eric

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
 
E

Eric

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
 
Top