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

=LARGE(A1:A10,2)

Juan Pablo G.

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

John --

It's

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

Aladin

=========