Question about returning some values from highest to lowest

[Cory from Eugene]

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

(e-mail address removed)

 

[T. Valko]

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))

 

[Cory from Eugene]

but what about the 2nd highest value and so on?

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))

 

[T. Valko]

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