Top 25 List of Times

T

thscc1659

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
 
T

thscc1659

I figured out how to get the Top overall times. All I need now are the
fastest times by class level. Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top