RANKX for each date

[xvanwindekens]

Hi, 

I am trying to rank players for each day in one table and calculate the rank difference between dates for a same player in another column. Note that there is a gap between some dates and the ranking is descending.  

Data:

Date	Player	Score
1/1/2017	John	12
1/1/2017	Nico	2
1/1/2017	Steve	7
1/1/2017	Ben	4
1/2/2017	John	25
1/2/2017	Nico	28
1/2/2017	Steve	26
1/2/2017	Ben	28
1/3/2017	John	39
1/3/2017	Nico	37
1/3/2017	Steve	40
1/3/2017	Ben	35
1/6/2017	John	47
1/6/2017	Nico	49
1/6/2017	Steve	47
1/6/2017	Ben	46

Desired table

	1/1/2017	1/2/2017	1/3/2017	1/6/2017
Player	Score	Rank	Diff	Score	Rank	Diff	Score	Rank	Diff	Score	Rank	Diff
John	12	4	-	25	1	+3	39	3	-2	47	2	+1
Nico	2	1	-	28	3	-2	37	2	+1	49	4	-2
Steve	7	3	-	26	2	+1	40	4	-2	47	2	-2
Ben	4	2	-	28	3	-1	35	1	+2	46	1	-

Thank you for your help.

[Ashish_Mathur · Accepted solution]

Hi,

You may refer to my solution here.

Hope this helps.

[xvanwindekens]

Thank you !

[Ashish_Mathur]

You are welcome.