Displaying 1st-8th of a set of data

[Rhett19]

My worksheet is basically a track and field data handler.
I want to make the following

HEAT 1(as a page heading)
LANE(column heading=ch) CONTESTANT(ch) SCHOOL(ch) TIME(ch) PLACE(ch)

The lane, contestant, and school will be entered beforehand. Time will be entered at the time of the race. Can I then make excel choose between all the times and assign/display a place(ex. 1st-8th) to each time?

Thanks in advance for all the help

MORE QUESTIONS TO COME LATER!!!