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

Thanks to everyyone that helped me before

The problem i have is that i want to be able to extract data from one sheet
and put it in another.
So far i have managed (with help) to get the top 10 names and scores to
appear on another tab but i would like to add one more column which is the
year
The data is held in

names = A3 to A220
Year = B3 to B220
Score = P3 to P220

There is other data inbetween Column B and P so i can't use the conventional
sort option

The calulation i used to get some of the data so far is
=INDEX(Sickhistory!A$3:A$220,MATCH(LARGE(Sickhisto ry!P$3:P$220,ROW(B1)),Sickhistory!P$3:P$220,0)

Hope someone can help
Reply
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
Top 10 Ranking louiscourtney Excel Discussion (Misc queries) 10 July 19th 07 03:28 PM
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 Curtis Excel Worksheet Functions 5 May 14th 06 03:59 AM


All times are GMT +1. The time now is 11:06 AM.

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"