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!

School work?

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

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"Session101" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

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

Regards,
Howard

"Session101" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>