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