Spreadsheet advise

%3CLINGO-SUB%20id%3D%22lingo-sub-1583298%22%20slang%3D%22en-US%22%3ESpreadsheet%20advise%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1583298%22%20slang%3D%22en-US%22%3ECould%20you%20please%20recommend%20the%20best%20way%2Ffunction%20to%20create%20a%20drone%20race%20spreadsheet%3A%3CBR%20%2F%3EI%20need%20to%20record%20pilots%20time%2Bnumber%20of%20laps%2C%20I%20need%20the%20spreadsheet%20to%20determine%20three%20winners.%3CBR%20%2F%3E%3CBR%20%2F%3EA%20race%20will%20have%205%20%E2%80%9Chits%E2%80%9D%20-%20it%20will%20record%20pilots%20time%20(seconds)%20and%20number%20of%20laps.%20In%20the%20end%20of%20the%20race%2C%203%20best%20hits%20(shortest%20time%2C%20most%20laps)%20will%20determine%20winners.%202%20worst%20hits%20will%20be%20dropped%20for%20each%20pilot.%3CBR%20%2F%3E%3CBR%20%2F%3EShould%20I%20do%20a%20pivot%20table%20for%20that%3F%20Or%20logical%20function%3F%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20you%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1583298%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1583380%22%20slang%3D%22en-US%22%3ERe%3A%20Spreadsheet%20advise%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1583380%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F756612%22%20target%3D%22_blank%22%3E%40AnnaVWilliamson%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Edoes%20this%20do%20the%20job%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1584367%22%20slang%3D%22en-US%22%3ERe%3A%20Spreadsheet%20advise%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1584367%22%20slang%3D%22en-US%22%3EThank%20you%20very%20much%2C%3CBR%20%2F%3E%3CBR%20%2F%3EThis%20is%20very%20helpful!%3C%2FLINGO-BODY%3E
Highlighted
New Contributor
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?

Thank you
2 Replies
Highlighted

@AnnaVWilliamson 

 

does this do the job?

Highlighted
Thank you very much,

This is very helpful!