Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 40
Default Top 10 Ranking

I would like to be able to set up an extra tab in my worksheet that gives me
the top 10 performers
I can't use the normal filter sort as not all the cells are the same size
and it all goes out of sync

The sheet where the information is held is layed out as follows
Column A has all the names from A3 down to A220
then there is various other columns with other data until we get to column P
which has totals in it

Column P3 down to P220

What i would like is some sort of caluculation that picks up the name then
the corresphonding amount and then sorts it into the top 10 perfromers

And then enters the information on the seperate tab

Any help would be appreciated
 
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 casdaq Excel Worksheet Functions 1 March 28th 07 02:26 AM
Ranking Teethless mama Excel Worksheet Functions 0 March 28th 07 12:23 AM
Ranking casdaq Excel Worksheet Functions 0 March 28th 07 12:09 AM
Ranking linzi00 Excel Discussion (Misc queries) 2 October 5th 06 05:42 PM
ranking Soz Excel Worksheet Functions 6 September 14th 05 05:55 PM


All times are GMT +1. The time now is 09:50 PM.

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

About Us

"It's about Microsoft Excel"