Results 1 to 5 of 5

ranking excluding 0

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

  1. #1
    New Member
    Join Date
    Mar 2010
    Posts
    3

    Default ranking excluding 0

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

  2. #2
    Board Regular
    Join Date
    Apr 2004
    Posts
    6,715

    Default Re: ranking excluding 0

    =if(c21=0,"",rank(c21,$c$21:$c$26))
    Yesterday I felt on top of the world. Today its falling in on me.

  3. #3
    New Member
    Join Date
    Mar 2010
    Posts
    3

    Default Re: ranking excluding 0

    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

  4. #4
    Board Regular
    Join Date
    Nov 2006
    Location
    London
    Posts
    3,098

    Default Re: ranking excluding 0

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

  5. #5
    New Member
    Join Date
    Mar 2010
    Posts
    3

    Default Re: ranking excluding 0

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

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com