Determining the 2nd highest number in a list

[Jchess]

I have a named range containing numbers. By what formula can I determine the second largest number in the range? Sorry for asking such a basic question - I left my brain at home today. I've got nothing.

[Alex O]

One possibility would be:
B2:
=RANK(A2,$A$2:$A$7,1)
C2:
=RANK(B2,$B$2:$B$7,1)

Just modify the range accordingly and this should at least get you started.

[mikerickson]

Try
=LARGE(A1:B10, 2)

[Jchess]

My thanks to both of you who replied to my cry for help. Both suggestions were useful. I ended up using the LARGE function (I wasn't aware the function existed).