Rank with duplicates

[Anonymous]

I have a column that has days since trade  from today, so a trade yesterday would be 1, day before 2 etc. We do many trades to there could 100 trades designated with a 2. How could I rank this column? There can be gaps in the days since trade if there is a day when no trades are done - like weekends. I am looking for something that would return something like this - easy enough to do in excel:

Days since trade	Rank
1	1
1	1
1	1
1	1
2	2
2	2
2	2
4	3
4	3
4	3
7	4
7	4
7	4
7	4

[Anonymous]

Thank you, I used this language:

Rank Calc = RANKX('Sheet1',Sheet1[Days since Trade],,ASC,Dense)

But get this?

[amitchandak]

@Anonymous , try a new column like

rank = rankx(Table,[Days since trade],,asc,dense)

[Anonymous]

thanks I get a 'Token Literal expected" error

[amitchandak]

@Anonymous , Please find the attached file after signature