LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Select and Display top 5 results

my worksheet (score/time sheet) has many Names and times

Name Time1 Time2 club memberid

fred 2.30 2.15 ABC 256
sam 2.13 2.37 GHJ 158
sue 1.58 1.50 XYZ 188

on a new worksheet i want to calculate the following only to 5th place
what is the best function to use and how

1st name time
2nd name time


 
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
How to select numeric 'series axis' in a surface chart? S.Grossmann Charts and Charting in Excel 4 March 9th 06 02:58 PM
how to display subjects taught by a specific teacher upon selection of the teacher name in a drop down box janice fernandes New Users to Excel 5 March 9th 06 12:24 PM
Restarting a macro BR Excel Worksheet Functions 19 December 23rd 05 09:57 PM
multiple results display after filter function Morphyus C via OfficeKB.com Excel Worksheet Functions 1 August 11th 05 03:17 PM
How select an item in a list box jamie81 Excel Worksheet Functions 1 May 31st 05 09:53 AM


All times are GMT +1. The time now is 03:45 PM.

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

About Us

"It's about Microsoft Excel"