I am tracking athlete performance in a spreadsheet. I want to pull the date that the top three times are run using Xlookup. It works great until an athlete has the same time twice as the Xlookup returns the date associated with the first instance of the time. How can I find the correct date for each time even if there are duplicates? Thanks for any help you can provide.
Undeclared Cross-Post can be found here:
https://www.mrexcel.com/board/thread...array.1165619/
Bookmarks