ranking

[Guest]

I have only a basic knowlege of excel.
background: I have teams that are walking (counting steps) as well as
providing weight reduction (in lbs).

I have calculated the % increase in number of steps taken over a period. At
the bottom of the spreadsheet I would like to show the top three teams with
the greatest % increase in number of steps (most improvement) over that
period.

I would like to show the name of the team (which is in column A) and their %
(which is in column N)
What formula, if any, do I use to do this?

 

[Intruder 9]

Check this out
http://www.cpearson.com/excel/rank.htm

 

[Mladen_Dj]

I would like to show the name of the team (which is in column A) and their
%
(which is in column N)
What formula, if any, do I use to do this?

For % of the team use LARGE function. For example in table with range A1:N9

=LARGE($N$1:$N$9;1) for top team,
=LARGE($N$1:$N$9;2) for second team,
=LARGE($N$1:$N$9;3) for third team.

To get names of teams use INDEX function:
=INDEX($A$1:$N$9;MATCH(LARGE($N$1:$N$9;1);$N$1:$N$9;0);1) for top team,
=INDEX($A$1:$N$9;MATCH(LARGE($N$1:$N$9;2);$N$1:$N$9;0);1) for 2nd,
=INDEX($A$1:$N$9;MATCH(LARGE($N$1:$N$9;3);$N$1:$N$9;0);1) for 3rd.

 

[Guest]

Thank you for making this look so easy. I would have never figured it out.
I really appreciate your help.

 

[Domenic]

What if there are two or more teams tied for third place?