Dynamic Update to Range in RANK Based on Date

[multifidus]

I am building an NBA stats workbook where I have separate sheets for each stat (points, rebounds, etc.). I am tracking this data in one sheet and I have the date of the game for that player in column A. One of the stats that I am tracking is the difference between the player's average for that stat and how much they got that game (for example, a player may average 20 points a game, but that game they scored 30 points so that cell would be 10). Based on this difference in value, I am ranking the players for that day. Because I have all of the data for this stat for the entire season in one sheet I am currently changing the range for the rank manually using the following formula:

=IF(ISBLANK(R3), "",COUNTIFS($A$3:$A$14,A3,$R$3:$R$14, ">"&R3)+1)

A = Date (A3:A14 are the only players I am tracking that day; A15 would start the next day's games)
R = Difference in average to the stat for that game.

I would like to figure out a formula where all of the range values would automatically update to only include rows where the date is the same.

Any suggestions?