ranking
 

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?

ranking
 

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

"tagraeff" wrote in message
...
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?

ranking
 

"tagraeff" wrote in message
...


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.

ranking
 

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

"Mladen_Dj" wrote:


"tagraeff" wrote in message
...


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.

ranking
 

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

In article ,
"tagraeff" wrote:

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

"Mladen_Dj" wrote:


"tagraeff" wrote in message
...


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.