(Edited for better readabiliy; Lupp)

*(The formula below should be entered for evaluation in array-mode.)*

`=IF(JC11=0;"";RANK(JC11;IF($JC$11:$JC$100>0;$JC$11:$JC$100;1))+COUNTIF($JC$11:$JC$11;$JC$100)-0)`

I found this on the net, works great. One thing, I need it reverse order

show smallest to equal “1” not max equal “1”.

where do I put the “,1” or how can it be changed to show Rank smallest to max

(i’ve tried several scenario’s nothing seems to work)

thank you in advance for any help provided.