Thread: sorting or categorizing "race results" table

Hi there experts,

I have been composing a “race timer” sheet with which I could record times in a race where people run/ride/drive multiple laps. As I don´t know too much Visual Basic, I have been using simple lookuptables, pivot tables, IF functions and such.

I have managed to enter lapping time events (yellow tab) and calculate the final times (blue tab) but I would need help in categorizing the final results in various classes and in the order of quickiest time. Now I have done this with recording a macro to sort a range (green tab). In this I cannot include “automatic” position indices and the different callses are not too well separated from each others. What I would like is something in the last tab. Any advice would be appreciated. I have attached the sheet.

Thanks Timo

Hi JBeaucaire,

Thanks for a quick reply. Actually I ment something else, sorry for my not-so-clear description above. I am quite happy with my calculations and the final time in the "aikaleimat" tab. My problem is purely in sorting the data in the grey cells in the "aikaleimat" tab so that it is clearly readable.

So, basically from that data I want to find all "A" class racers and put those in descending order with laps and ascending order with final time and index the results with position index. And the same for all the other classes. There could be dozens of competititors in the table and the users of the sheet may have not too much of experience in excel so I would need some "automatization" in the table.

Thanks again, I hope this clarified my problem more.

BR Timo