Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Rank with duplicates

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...
Need Help
amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , try a new column like

 

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    thanks I get a 'Token Literal expected" error