Use the third argument to sort ascending or descending
=RANK(A1,$A$1:$A$10,0)
sorts descending, (also if you leave the 0 out),
=RANK(A1,$A$1:$A$10,1)
sorts ascending,
Regards,
Alan.
"Excelicious" wrote in message
...
When I do the rank function it does it backwards. Meaning the lowest
value
has a higher rank. Can this be turned around?

--
Yeah that about sums it up.