Rank anything that doesnt equal zero

Hi

I am trying to ran a set of numbers, but within these numbers there are a large amount of zero's, this data will change each month as it depends on what month the user selects in the drop down.

I have tried

Formula:

=if(h2<>0,rank(h2,$h$2:$h$50),0)

But this just ranks the zeros as 0 and still ranks anything less than zero as like 45,46,47 etc because its still counting all the cells its looking at.

How can i make the formula only rank numbers that DO NOT equal 0?

Any help is appreciated

Cheers

Dan