Working out positions based on time

[Vinnie]

Basically I'm doing some timing for a Mountain Bike downhill race, and
am going to have a whole bunch of times for a race in one column (I
and in another column (J) I want to automatically work out a placing
based on the times as I enter them into the spreadsheet (sort of like
'live' placing system, which adjusts based on peoples times as the
come down the hill. eg. So a person who came down in fifth initiall
could be bumped back to sixth when the next rider comes down the hil
if they post a faster time than the first rider does).

Is this possible? If it isn't, even a formula to work out the placing
once all the times are entered into the spreadsheet would also work fo
what I want.

Also please note, that I don't want the sheet to automatically sor
itself based on position. I want the data to stay in its existin
order (otherwise the riders are out of place for the next time the
come down the hill as they will run in the same order as the firs
time).

Hopefully this is enough information,

Thanks for you help,

Vinnie :

 

[Frank Kabel]

Hi
as a starting point have a look at
http://www.cpearson.com/excel/rank.htm

 

[Bob Phillips]

Hi Vinnie, just use this formula

=IF(A1<>"",RANK(A1,$A$1:$A$10),"")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)