View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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