Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
DROPDOWN LIST OF TIMES nando Excel Discussion (Misc queries) 6 April 4th 23 02:31 PM
LIST OF THE NUMBERS, AND HOW MANY TIMES THEY REPEAT? dperalta Excel Worksheet Functions 3 July 18th 08 06:25 PM
Find the figur that are represented most times in at list Palle korsholm Excel Worksheet Functions 1 May 21st 08 01:15 PM
Add a list of times jmcclain Excel Worksheet Functions 1 May 14th 07 08:08 PM
How do I add a list of times to get an average time? Matt75 Excel Discussion (Misc queries) 1 January 11th 06 03:07 PM


All times are GMT +1. The time now is 07:43 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"