Instead of a literal as the 2nd argument, use a formula based on the row
number. e.g. if the first formula is in Q8,

=LARGE($P$4:$P$65536,ROW()-ROW($Q$8)+1)

or

=LARGE($P$4:$P$65536,ROWS($Q$8:$Q8))

On Mon, 26 Sep 2005 09:40:04 -0700, 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.

"Domenic" wrote:

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