Rank based on criteria in two columns & Assign points based on rank and number participant

Good Morning,

I'm having issues ranking based on two criteria. In column H is "Furthest Station" and column I is "Total Time".

Athlete who makes it to the furthest station in the fastest time will rank 1 then down the line. I've attached a Before and After. I've already sorted the athletes based on station and time. Men and women are ranked independently. Rank 1 gets the most points based on total number of athletes. So if you are 1st out of 6 people you get 6 points, next person gets 5 points, etc... Points are shared if you rank the same as someone else. Ex. tie for 2nd with 6 people total so they share points 5 + 4 = 9 so 4.5 each and each rank 2nd.

I've been playing with SUMPRODUCT, COUNTIFS, IF statements but can't seems to get it right. This is for a non-profit who scores events on paper and we are trying to reduce human error for athletes.

Any help is appreciated. I'll upload my excel workbook.

Simplest method I can think of is to add helper column (Inserted before Points, in column J)
=H2-I2/1000

Points column formula (Column K):
=1+COUNTIFS($B$2:$B$14,B2,$J$2:$J$14,"<"&J2)

Rank column formula (Column L):
=1+SUMPRODUCT(($B$2:$B$14=B2)*($J$2:$J$14>J2))

Edit: Adjust /1000 to larger number if needed.

Taking into account that you would like the points for ties to be split, the following proposed solution with two helper columns (which may be hidden for aesthetic purposes) is offered.
The formula that populates the first helper, a column of ranks disregarding ties, is:

Formula:

Please Login or Register  to view this content.

The formula that populates the second helper, a column which assigns points to a rank is:

Formula:

Please Login or Register  to view this content.

The formula that populates column K is:

Formula:

Please Login or Register  to view this content.

The formula that populates column J is:

Formula:

Please Login or Register  to view this content.

Note that the time in E12 has been changed to illustrate how the solution works for ties.
I have only done limited testing.
Let us know if you have any questions.

Try pasting the following formula into cell J2, then copy down:

Formula:

Please Login or Register  to view this content.

Let us know if you have any questions.