How to determine the second large value from a list?

  • Thread starter Thread starter Eric
  • Start date Start date
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to determine the value - 18 Dec? 5
How to determine the values? 1
How to determine the first 6 large numbers from a list? 4
How to determine the closed value? 7
How to determine the value from a list? 6
How to determine the minimum difference between values? 3
How to determine the values? 1
How to determine the value? 1

Back
Top