Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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)) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to sum cells and ignore the #div/0! 's ? | Excel Worksheet Functions | |||
how do you "select locked cells" w/o "select unlocked cells"? | Excel Discussion (Misc queries) | |||
Trendline to ignore empty cells | Charts and Charting in Excel | |||
Help adding text values | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |