Excel 2007 : ranking in excel

hello,
where having a festival shortly in my area and was wondering could anyone help me.we have 12 competitors in a strongman competition,what i have is there names in column A and when i enter there time for the first event in column B,then column C,D will show there names and time again in order ei 1st,2nd,3rd etc or maybe some one will know a better way to do this.we will have 6 events in total.thanks.

perfect thanks alot.

Hello again,
Sorry to go back to this again,your spreadsheet is perfect but if you ever seen the competitions on tv the person with fastest time in an event gets alocatted points,for example if strongman9 wins an event he gets 10 points and 8 for second etc.Is it possible to include a points system with each event and also keep the ranking.If its not,i'll get around it some how but thanks for your help anyway.

Thanks again for your time,looks exactly like what i need.

hello,
hopefully mr.mrice will not mind replying to this,your attachment on the 18/8,which is perfect i can follow everything but how did you get column R to correspond with column S.im sorry i am only getting back to this now,but i tried to remake your sheet but columns R,S dont correspond like yours.like if strongman1(sm1) has 30pts strongman2(sm2) =25pts and if sm2 then wins the next event and gets 10 extra pts then goes to 35.he should then leap frog sm1 in column R like in your sheet,but in mine it doesnt.tell me what am i doing wrong.Thank you.

thanks again,I didnt see the macro.