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:DatePlayerScore1/1/2017John121/1/2017Nico21/1/2017Steve71/1/2017Ben41/2/2017John251/2/2017Nico281/2/2017Steve261/2/2017Ben281/3/2017John391/3/2017Nico371/3/2017Steve401/3/2017Ben351/6/2017John471/6/2017Nico491/6/2017Steve471/6/2017Ben46 Desired table 1/1/20171/2/20171/3/20171/6/2017PlayerScoreRankDiffScoreRankDiffScoreRankDiffScoreRankDiffJohn124-251+3393-2472+1Nico21-283-2372+1494-2Steve73-262+1404-2472-2Ben42-283-1351+2461- Thank you for your help.

Hi, You may refer to my solution here. Hope this helps.

Regular Visitor

8 years ago

Solved

RANKX for each date

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
8 years ago
Hi,

You may refer to my solution here.

Hope this helps.

Forum Discussion

RANKX for each date

3 Replies

Related content

Rankx with Dates

RankX

RANKX with date hierachy and column charts

RANKX by date

RANKX