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))
``````
Who is Participating?

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Commented:
RANK has three parameters. The third one determines if the order is ascending (any value but 0) or descending (missing or 0).
0
Commented:
You formula should be like this:

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

jppinto
0

Experts Exchange Solution brought to you by