Results 1 to 3 of 3

Ranking Positive/Negative but Not Zeros?

This is a discussion on Ranking Positive/Negative but Not Zeros? within the Excel Questions forums, part of the Question Forums category; I'm can't figure out how to do this?   N O P 23   Sales Rank 24 John 500 3 ...

  1. #1
    Board Regular
    Join Date
    Aug 2007
    Posts
    101

    Default Ranking Positive/Negative but Not Zeros?

    I'm can't figure out how to do this?


     NOP
    23 SalesRank
    24John5003
    25Bob3004
    26Larry7502
    27Mary9001
    28Joe0 
    29Bob-5005


    Excel tables to the web >> Excel Jeanie HTML 4

  2. #2
    Board Regular iggydarsa's Avatar
    Join Date
    Jun 2005
    Location
    One of the Blue States
    Posts
    1,535

    Default Re: Ranking Positive/Negative but Not Zeros?

    put this formula in P24 and drag down

    =IF(O24<0, RANK(O24,$O$24:$O$29) - COUNTIF($O$24:$O$29,0), IF(O24=0, "", RANK(O24,$O$24:$O$29)))

  3. #3
    Board Regular
    Join Date
    Aug 2007
    Posts
    101

    Default Re: Ranking Positive/Negative but Not Zeros?

    That worked, thank you iggydarsa!

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