Multi-Row formula

If there is a same rank, then next rank should be increment of plus 1. For example, if there are two 1st Rank, then next one should be 3 rank. I have already used Multi-row formula for achieving attached results. Please assist me with this. Thanks in Advance.

MR.PNG

Data Investigation

Accepted answers

Qiu

@Sarath27
That is exactly weekly challenge #122.

https://community.alteryx.com/t5/Weekly-Challenge/Challenge-122-Think-Like-a-CSE-Ranking-Data/td-p/177006😁

All comments

caltang

Not sure what you mean exactly @Sarath27 - can you explain it more clearly and provide an expected output file + your data so that we can look at it?

Alternatively, if you can't share, try using the Tile Tool and Group By the Rank. Your tile_sequence_num should be what you want if I understand you correctly. Use a Select Tool thereafter to rename and choose the fields of your liking.