Question about returning some values from highest to lowest
 

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

Question about returning some values from highest to lowest
 

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

Question about returning some values from highest to lowest
 

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

Question about returning some values from highest to lowest
 

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