ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Top 25 List of Times (https://www.excelbanter.com/excel-worksheet-functions/228720-top-25-list-times.html)

thscc1659

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


thscc1659

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