ranking

T

tagraeff

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?
 
M

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?
Click to expand...

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.
 
T

tagraeff

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