I’m tracking athletes top run times. Need to get top 3 times (including duplicates) and the associated dates. Dates are in row 1. Times start in row 2. I use SMALL to get best times. When using XLOOKUP to return the date, if a time is duplicated the formula pulls the date associated with the first instance of the time. I need the formula to pull the date in row 1 in the same column as the duplicate time. In the attached image, I’d like the formula in the cell with red border to return 1/5/21.
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!