Thread: ranking
View Single Post
  #1   Report Post  
tagraeff
 
Posts: n/a
Default 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?