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
=========
