Could you please recommend the best way/function to create a drone race spreadsheet: I need to record pilots time+number of laps, I need the spreadsheet to determine three winners.
A race will have 5 “hits” - it will record pilots time (seconds) and number of laps. In the end of the race, 3 best hits (shortest time, most laps) will determine winners. 2 worst hits will be dropped for each pilot.
Should I do a pivot table for that? Or logical function?