RANKEQ is not ranking sequentially

Options

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.


Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!