I'm having big problems with the below....
1) Firstly Column W in the main table, this was intended to rank the riders as the times come in, at the moment it sort of works, however as I am using a Time format in the other columns I cant seem to get it to only rank once a time above 00:00:01 is registered? ie it just ranks regardless, including no time 00:00:00 (a lower time is better).
(although if possible, it would be most excellent if the rank did not display untill all 6 stages were completed! Perhaps saying "In progress" if not)
2) I've then been trying to create an auto updating leaderboard (Table A46:C41)
At the moment I've got it to pull through names in rank order (although the wrong way round!) but I cant get it to pull through the times.
You help would be much appreciated so that I can help run this race!
Thanks in advance
Simon
Bookmarks