ranking athletes based on best time

I have a track and field spreadsheet and I need to rank the athletes best times against each other but excluding their other times. ex. I have 3 athletes that have each ran the distance 3 separate t...