Ranking Swimmers times in an automatically updating table

[GeoGeeBlack22]

Hello,
I am currently working on way to track my swimmers times over the course of a season and track what place they maintain on my team. The current problem that I am running into is that if two swimmers go the same time the two times separately show up in the ranks... but there is only one swimmers name that claims that specific time, leaving a swimmer getting left out and one being doubled.

The sort formula below is used to sort data from the data sheet of everyone's individual times, the XLOOKUP( Function is used to pair that time with it's name pair. I added the Unique( Function to the xlookup so that maybe it would only bring up one name. It was unsuccessful, unfortunately. These specific formulas are used in the 100 Fly chart that has a double up on the swimmer "Jorge Guerra" and is missing the time for swimmer "Christian Steele" who has the same time as him at a 52.25. This same issue happened in the 50 Free chart that is attached with "Roberto Griffith".

I have entered all data with an apostrophe at the beginning because of the way excel hate swim times, especially those from swimming. Example: '52.25 which shows as 52.25 in text form.

I have rattled every part of my brain and tried to lookup different formulas and just can't seem to find a solution. Does anyone have any advice or a solution? It would be very helpful!

 

[Fluff]

Hi & welcome to MrExcel.
How about

=SORT(FILTER(FILTER('Men Swimming Data'!A2:L29,'Men Swimming Data'!L2:L29<>""),(COLUMN('Men Swimming Data'!A2:L2)=1)+(COLUMN('Men Swimming Data'!A2:L2)=12)),2)

 

[GeoGeeBlack22]

Hi & welcome to MrExcel.
How about

=SORT(FILTER(FILTER('Men Swimming Data'!A2:L29,'Men Swimming Data'!L2:L29<>""),(COLUMN('Men Swimming Data'!A2:L2)=1)+(COLUMN('Men Swimming Data'!A2:L2)=12)),2)

This Worked! Thank you so much! You really saved me. I had spent 8 hours yesterday trying to research and now the problem has been solved thank you so much!

 

[Fluff]

You're welcome & thanks for the feedback.