Excel Formulas and Functions

%3CLINGO-SUB%20id%3D%22lingo-sub-2212652%22%20slang%3D%22en-US%22%3EExcel%20Formulas%20and%20Functions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2212652%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20Surface%20Pro%20with%20Win%2010%20Home%2C%2020H2%20and%20Office%20%3CSPAN%3EVersion%3C%2FSPAN%3E%3CSPAN%3E%20%3A%20%3C%2FSPAN%3E%3CSPAN%3E18.2008.12711.0%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20have%20created%20a%20spreadsheet%20to%20track%20times%20and%20ratings%20in%2013%20events.%26nbsp%3B%20I%20am%20trying%20to%20create%20a%20formula%20to%20look%20up%20the%203%20fastest%20times%20in%20each%20event%20and%20return%20the%20value%20of%20the%20rating%20for%20the%20slowest%20of%20the%203%20times.%26nbsp%3B%20I%20am%20a%20horse%20trainer%20and%20trying%20to%20keep%20track%20of%20my%20students%20ratings%20for%20year%20end.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3Eexample%3A%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CTABLE%20width%3D%2292%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2250%22%3E32.096%3C%2FTD%3E%3CTD%20width%3D%2242%22%3EFC%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E23.343%3C%2FTD%3E%3CTD%3EA%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E44.240%3C%2FTD%3E%3CTD%3EFC%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E23.517%3C%2FTD%3E%3CTD%3EA%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E24.476%3C%2FTD%3E%3CTD%3EA%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20would%20be%20GREATLY%20appreciated.%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2212652%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I have a Surface Pro with Win 10 Home, 20H2 and Office Version : 18.2008.12711.0

 

I have created a spreadsheet to track times and ratings in 13 events.  I am trying to create a formula to look up the 3 fastest times in each event and return the value of the rating for the slowest of the 3 times.  I am a horse trainer and trying to keep track of my students ratings for year end.

 

 

example: 

32.096FC
23.343A
44.240FC
23.517A
24.476A

 

Any help would be GREATLY appreciated.

Thank you

1 Reply

@jdonati379 

How example in the post is correlated with file you attached? Perhaps you may manually add desired result for one of the events into the file for better understanding of what is required.