Hi Laurie

You don't say whether it is based on Time 1, Time 2 or an aggregate of
both times.

A simple, non formula solution might be to copy the data to another
sheet, mark the whole block of data and sort by the relevant time
column. Either hide or delete the data you don't want to show.
(If it is based on the aggregate times, then create a column adding the
times and use this as the sort column)
--
Regards

Roger Govier


"laurie g" <laurie wrote in message
...
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