I just made a table for a sports league my friends and I are doing in that we make guesses on who will score the game-winning-goal in an NHL game and I want to know how to break ties.

Here are examples of the columns I have:

Right picks Percentage Player
5 15 A
10 10 B
6 9 C
3 5 D
4 20 E
5 19 F

I used rank and got the rankings, but you can see, Player A and F had the same number of correct picks. When I use RANK that really isn't a problem, but I don't want to see both people listed in 3rd place.

i made a finalized standings table using vlookup and player F's name and numbers completely disappear and all it says is #N/A.

How do I use the percentage column as the tie breaker?

I want excel to know that if two or more players are tied, then whoever has the higher percentage would get the higher seed. Can somebody help me out?