Prev Previous Post   Next Post Next
  #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?



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Ranking range of cell with value only cardingtr Excel Discussion (Misc queries) 10 September 19th 05 12:46 PM
Numbers used for Ranking Lowkey Excel Worksheet Functions 4 May 27th 05 11:26 PM
Ranking Using Grand Total nostalgie Excel Discussion (Misc queries) 0 April 9th 05 03:27 PM
Ranking Thrava Excel Discussion (Misc queries) 6 February 15th 05 10:49 AM
Problem with ranking numbers Pati M Excel Worksheet Functions 1 November 23rd 04 11:29 PM


All times are GMT +1. The time now is 02:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"