Question about returning some values from highest to lowest

  • Thread starter Thread starter Cory from Eugene
  • Start date Start date
C

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)
 
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))
 
but what about the 2nd highest value and so on?

T. Valko said:
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))
 
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
 
Back
Top