One way:

=LARGE(A:A,2)

In article ,
"Keith" wrote:

I am attempting to do inventory analsysis where I need to pick the highest
and second highest values from a row of numbers. I can get the highest by
using the MAX function....how do I get the second highest number?