Mar 15 2021 08:41 PM - edited Mar 15 2021 09:06 PM
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.096 | FC |
23.343 | A |
44.240 | FC |
23.517 | A |
24.476 | A |
Any help would be GREATLY appreciated.
Thank you
Mar 16 2021 01:46 AM
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.