Making the formula ranking lowest value first instead of highest value first.

[dudleyscud]

Hi I have a sheet with a formula that ranks a value in order having the highest value ranked as 1 then the next 2 and so on. I cant figure out how to have the lowest value ranked as 1 then the second lowest 2 and so on.

My excel sheet lists all the horses for todays racing so I want to rank every horse in a race and every race of the day.

Here is the formula

=IF(OZ2=0,0,SUMPRODUCT(--($OV$2:$OV$20000=OV2),--(OZ2<$OZ$2:$OZ$20000))+1)

OZ is the value i want ranked and OV is the unique race name.

Hope that makes sense.

 

[dudleyscud]

Surely someone knows???