For the second highest...

=LARGE($P$4:$P$65536,2)

For the third highest...

=LARGE($P$4:$P$65536,3)

....and so on.

Hope this helps!

In article ,
Jim wrote:

Returning Descending Values

I currently use the following to find the max number is a column:
=MAX($P$4:$P$65536). If I wanted to find the second highest, then the third
highest, etc.. how would this be written?

Thanks for the help