Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Top 25 List of Times
I have a spreadsheet with the times run by individuals over a 3 year span.
I've been able to create a Top 25 list out of those times, but am having trouble with some other aspects (only part of the table is shown, so hopefully it will be enough). I want to: a) have Excel give me the name of the runner next to the Top 25 time b) create a Top 25 list without any repeat runners and give the name with the time c) create a Top 10 list for indvidual classes (i.e. Freshman, Sophomore, Junior, Senior) Ben Bach 32:47.00 PAC Championship 46 1 28:01.52 Larry Stange 37:18.00 PAC Championship 60 2 28:17.80 Stephano Kaiser 38:00.00 PAC Championship 63 3 28:20.60 Chad Schmidt 30:33.00 PAC Championship 38 16 4 28:27.51 Josh Horn 33:21.00 PAC Championship 65 27 5 28:30.73 Ben Bach 34:25.00 PAC Championship 68 29 6 28:39.79 Justin Egan 37:04.00 PAC Championship 80 31 7 28:42.39 Kevin Keller 40:11.00 PAC Championship 81 32 8 28:52.41 Casey Wechbach 56:21.00 PAC Championship 83 34 9 28:52.53 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Top 25 List of Times
I figured out how to get the Top overall times. All I need now are the
fastest times by class level. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
DROPDOWN LIST OF TIMES | Excel Discussion (Misc queries) | |||
LIST OF THE NUMBERS, AND HOW MANY TIMES THEY REPEAT? | Excel Worksheet Functions | |||
Find the figur that are represented most times in at list | Excel Worksheet Functions | |||
Add a list of times | Excel Worksheet Functions | |||
How do I add a list of times to get an average time? | Excel Discussion (Misc queries) |