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.
=RANK(O18,($O$12,$O$15,$O$18,$O$21,$O$24,$O$27))

Open in new window

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

 =RANK(O18,($O$12,$O$15,$O$18,$O$21,$O$24,$O$27),1)

jppinto
0
 
jppintoCommented:
RANK has three parameters. The third one determines if the order is ascending (any value but 0) or descending (missing or 0).
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.