How to ignore cells in ranking?

  • Thread starter Thread starter cardingtr
  • Start date Start date
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)
 
Try...

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

Hope this helps!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Rank Function Help Needed 7
Ranking range of cell with value only 10
How to finding student Rank and How to upload bulk marks of each student at a time. 1
RANK based on result and average 5
How do I make a rank equation that omits particular cells? 1
Ranking range of cell with value 6
How to rank 9
Sumproduct - Return value as Blank 3

Back
Top