Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Ranking | Excel Worksheet Functions | |||
Ranking | Excel Worksheet Functions | |||
Ranking | Excel Worksheet Functions | |||
Ranking | Excel Discussion (Misc queries) | |||
ranking | Excel Worksheet Functions |