Find 2nd Largest Value

[Session101]

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!

 

[Peo Sjoblom]

School work?

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

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

 

[L. Howard Kittle]

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

Regards,
Howard