ranking duplicate values with secondary value

**awaring** · 06-01-2010, 06:38 PM

Is it possible with the ranking values with duplicates to utilize a secondary value?

I'm using this formula :
=SUMPRODUCT(($F$10:$F$55<$F$10)/COUNTIF($F$10:$F$55,$F$10:$F$55&""))+1

I have list of individuals with varying performance scores; at times some will come back with the same percentage and if there is an option of a secondary value to look for to always only rank 1 through an infinate number not skipping any or duplicating a ranking number.

Does this make sense?

**JBeaucaire** · 06-02-2010, 01:34 AM

'RANK-TIEBREAKING

Jerry Beaucaire's Excel Tools

(the file you want is Rank-TieBreaking.xls)

http://www.excelforum.com/excel-prog...-tables.html#2
http://www.excelforum.com/attachment...iebreaking.xls

**awaring** · 06-09-2010, 04:47 PM

is there a way to add into this formula, to exclude zeros from ranking?

**daddylonglegs** · 06-09-2010, 04:51 PM

Warning posted in error .....

**awaring** · 06-09-2010, 05:03 PM

This is my existing Thread and I have addtional questions, please advise.

**JBeaucaire** · 06-09-2010, 05:15 PM

With values in A1:A20, then a formula like so would skip ranking the cells with 0 in them:

=IF(A1=0,"",RANK(A1,$A$1:$A$20))

You can adapt that technique to your existing formula.