Require help breaking a RANK tie by using other cells data

[EzM_Ayce]

Hi all!

Firstly, first time poster (on any forum, not just this one) so please notify if I'm doing something wrong.
I looked for a long time for a solution to this query, but it was just getting confusing and didn't seem to fit my specific sheet. Thanks in advance for any help you can offer.

BACKGROUND:
I am currently hosting card game tournaments for my friends and I, and I am using Excel to track the data. Specifically the RANK formula.

Players compete in 'Matches' (best 2 of 3 'Games' wins a 'Match').
Two scores are recorded:
1: Players are awarded 3 'Points' for winning a 'Match'
2: A percentage is calculated on how many 'Games' a player wins.

ISSUE:
I want my formula to RANK the players based on their 'Points' (Awarded for winning 'Matches') but in the event of a tie, look up which player has the higher percentage (based on 'Games' won) and RANK them accordingly.

=RANK(J13,$J$13:$J$18,0)+COUNTIF($J$13:J13,J13)-1
This is the formula being used so far.

I am using Excel 2010 on a Windows 7 Laptop.

Sorry if a similar post had been made somewhere else.

In the Image, David and Robert both have the same 'Points' but as Roberts 'Percentage' is higher, I want him ranked above David.
Please ignore the "Percentage (M)" column, that's just there for later statistics, not ranking

ExcelRankIssue_zps96106d01.png Photo by Ezm_Ayce | Photobucket

Thank you all so much in advance. Please let me know if you need further information.

 

[jimrward]

create another column and add the percentage as a fraction to the points and then RANK on this new column

=points+(percentage/100) to give a decimal figure

 

[EzM_Ayce]

Wow, so simple!

And with formatting the cells to show no decimal points it does the job hidden behind the scenes! Thank you so much!!!!

EDIT: How do I mark this thread as solved? =)