Need rank function to reverse sort

I have 6 numbers I am trying to rank. It returns the ranks as 1 - 6, 1 being given to the highest number in the group. What I need to do is reverse that so the 1 is given to the lowest number. See attached code with what I am working with.

Open in new window

Cole100IT Systems ManagerAsked:
Who is Participating?
You formula should be like this:


RANK has three parameters. The third one determines if the order is ascending (any value but 0) or descending (missing or 0).
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.