MrExcel Publishing
Your One Stop for Excel Tips & Solutions

similar to MAX - 2nd highest value

Posted by John on December 14, 2001 7:12 AM

I want to find the second highest value in a range using something similar to the MAX function. Any suggestions?

Posted by Juan Pablo G. on December 14, 2001 7:17 AM


Juan Pablo G.

Posted by Aladin Akyurek on December 14, 2001 7:18 AM

John --


=LARGE(range,1) is same as =MAX(range)