Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |