ranking excluding 0

[jimmy jim]

hi,
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:
=RANK(C22;C21:C26)

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

 

[SteveO59L]

=if(c21=0,"",rank(c21,$c$21:$c$26))

 

[jimmy jim]

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.
frank.buschmann@intermediae.es

 

[Special-K99]

Steve's formula works for me. Copy it exactly as he typed it

 

[jimmy jim]

yep, now it works. i think there was a mistake rather in the formulas that created the values to rank. whatever. it works
thanks alot!!!