Find 2nd Largest Value
 

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

Find 2nd Largest Value
 

School work?

Take a look in help at the LARGE, INDEX and the MATCH functions

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"Session101" wrote
in message ...

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

Find 2nd Largest Value
 

In A5 use a LARGE formula.
In A6 use a VLOOKUP formula using A5 as part of it.

Regards,
Howard

"Session101" wrote
in message ...

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