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?
Bookmarks