Rank anything that doesnt equal zero

[shiftyspina]

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

Please Login or Register  to view this content.

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

[Pete_UK]

Change the final zero to "", and maybe change the comparison to greater than if you want to avoid the negative values.

Hope this helps.

Pete

[amy_d2]

may be try this

=IF(H2<=0,0,RANK(H2,$H$2:$H$50))

[shiftyspina]

Hi

Thanks it works now

Dan