How to ignore cells in ranking?
 

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))


--
cardingtr
------------------------------------------------------------------------
cardingtr's Profile: http://www.excelforum.com/member.php...o&userid=27027
View this thread: http://www.excelforum.com/showthread...hreadid=466392

Try...

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

Hope this helps!

In article ,
cardingtr
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))