Hi,

I have a list of values which i need to rank.

Some of the values are duplicates and some are zero.

I am using the following formula for ranking the duplicates:

=RANK(O3,O$3:O$84,0)+COUNTIF(O$3:O3,O3)-1

I want to modify the formula to exclude the zero values...

How do i do that?

Thanks....