RANKEQ is not ranking sequentially

Gaja Rm

With this formula couldn't able to rank the values sequentially

=RANKEQ(Values@row, Values:Values, 0)

Expecting All 100 to Rank 1

And 80 to Rank 2

and 70 to Rank 3.

Could you please help me out here.

Carson Penticuff

To do what you are asking, you can use the DISTINCT() function.

=RANKEQ(Values@row, DISTINCT(Values:Values), 0)

Carson Penticuff

To do what you are asking, you can use the DISTINCT() function.

=RANKEQ(Values@row, DISTINCT(Values:Values), 0)

Gaja Rm

Wowww Great, Thank you Carson