Hi all,
I am having difficulty, i am currently doing a football league table(3 points for a win, 1 for a draw etc). I am using the RANK function and the VLOOKUP to produce a live table based on results of matches i enter. My issue becomes where teams have equal points, and therefore say number 4 in RANK disappears to 2 threes. if i use the countif function to resolve this it just asigns the new ranks randomly. I currently have the following functions

=RANK(BI4,BI4:BI7,0) obviously the highlighted changes as i move down the table.
I have points in BI, but i want to get it so if the points in BI is level, it will Rank dependent on Goal Difference in BH, but only for the equal cells.

If somebody could have some answers for me it will be greatly appreciated.

Brady