If you start out in row 3 (for example) change it to

=large($P$4:$P$65536,row()-2)

"Jim" wrote:

Great answer to my questions. Thank you. One more follow up. How do I get
the number value to change when I am dragging down the cells? The 1 is
remaining the same.

"bj" wrote:

Try the Large() function
=large($P$4:$P$65536,1)
is the same as max()
=large($P$4:$P$65536,2)
is the second largest

Small() has a similar comparison to min()

"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