enter this formula in C1 and copy down as needed:
=LARGE(A$1:A$10,ROWS(C$1:C1))

Did you try it? The key phrase is *copy down as needed*.

As you drag copy down it will return the nth largest value. The ROWS()
function will increment like this:

=LARGE(A$1:A$10,ROWS(C$1:C1)) = large 1
=LARGE(A$1:A$10,ROWS(C$1:C2)) = large 2
=LARGE(A$1:A$10,ROWS(C$1:C3)) = large 3
=LARGE(A$1:A$10,ROWS(C$1:C4)) = large 4
etc
etc


--
Biff
Microsoft Excel MVP


"Cory from Eugene" wrote in
message ...
but what about the 2nd highest value and so on?

"T. Valko" wrote:

Try this:

With your numbers in the range A1:A10, enter this formula in C1 and copy
down as needed:

=LARGE(A$1:A$10,ROWS(C$1:C1))


--
Biff
Microsoft Excel MVP


"Cory from Eugene" wrote in
message ...
I have a groupe of numbers, and all I want to do is be able to return
the
highest of the group, then the second highest, third highest... and so
on.
Im
sure its an easy answer, but I just dont know how to do it.

Can anyone help me?

Thanks,
Cory