C
cardingtr
OK, I asked here before on how to ignore a range of cells that are empt
in ranking so it will not return an error. We got it fixed but I jus
found noe that if I put zero"0" in one of the cells to rank, it wil
also rank all other blank cells as "0" thereby resulting in all blan
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)
in ranking so it will not return an error. We got it fixed but I jus
found noe that if I put zero"0" in one of the cells to rank, it wil
also rank all other blank cells as "0" thereby resulting in all blan
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)