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 |
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! |
All times are GMT +1. The time now is 01:51 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com