How to ignore cells in ranking?

[cardingtr]

OK, I asked here before on how to ignore a range of cells that are empty in ranking so it will not return an error. We got it fixed but I just found noe that if I put zero"0" in one of the cells to rank, it will also rank all other blank cells as "0" thereby resulting in all blank cells with same value.

How do I ignore the blank cells? Here is my formula?

=IF(ISNA(RANK(G3,$G$3:$G$22,1)),"",RANK(G3,$G$3:$G$22,1))

[Domenic]

Try...

=IF(G3<>"",SUMPRODUCT(--($G$3:$G$22<>""),--(G3>$G$3:$G$22))+1,"")

Hope this helps!

In article <[email protected]>,
cardingtr <[email protected]>
wrote:

> OK, I asked here before on how to ignore a range of cells that are empty
> in ranking so it will not return an error. We got it fixed but I just
> found noe that if I put zero"0" in one of the cells to rank, it will
> also rank all other blank cells as "0" thereby resulting in all blank
> cells with same value.
>
> How do I ignore the blank cells? Here is my formula?
>
> =IF(ISNA(RANK(G3,$G$3:$G$22,1)),"",RANK(G3,$G$3:$G$22,1))