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
Bookmarks