View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
laurie g laurie g is offline
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