This is a discussion on ranking excluding 0 within the Excel Questions forums, part of the Question Forums category; hi, i would like to create the condition in the RANKing formula that all cells containing a 0 are not ...
i would like to create the condition in the RANKing formula that all cells containing a 0 are not included in the ranking
the formula is:
i would like to include something like this
IF C22=0 do not include calculating the ranking and display nothing in the cell displaying the rank for C22
thanks very much for help....
Yesterday I felt on top of the world. Today its falling in on me.
hi, thanks for this fast reply. i tried your suggestion, but no luck it tells me mistake in formular. tried various variations, but still.
if you can get it to work i would very much appreciate if you could send me a woorksheet with the formula functioning well.
maybe i am blind for some detail. i donīt know.
Steve's formula works for me. Copy it exactly as he typed it
yep, now it works. i think there was a mistake rather in the formulas that created the values to rank. whatever. it works