I have a table in Excel with these values:

100 Tim
50 Rich
80 Fiona
95 Orion


I need functions to return the 2nd largest value. Therefore, in cell
A5, I want to output the value 95. In cell A6, I want to output Orion
using Excel functions. TIA!


--
Session101
------------------------------------------------------------------------
Session101's Profile: http://www.excelforum.com/member.php...o&userid=14054
View this thread: http://www.excelforum.com/showthread...hreadid=531629