BlueWolverine wrote:
Hello,
MS EXCEL 2003 on XP PRO.

for the overall simplicity of my spreadsheet, I want to use a rank as a
unique identifier so I use VLOOKUPS. My problem is that RANK() is VERY
likely to return repeated ranks (3 second places for instance) and thus mess
up my whole day.

I found that the correction offered in F1 Help
=(COUNT(AB:AB) + 1 - RANK($AB4,$AB:$AB,0)- RANK($AB4,$AB:$AB,1))/2
to produce the same effect.

Does anyone have a recommendation on how to rank say,

{1,2,2,2,3,3,4,5,6,7} with out repeating the rank? (largest is Rank = 1)?
{10,9,8,7,6,5,4,3,2,1} are the ranks for each number in the set above
Thank you!







With your data in A2:A11, put this in B2 and copy down to B11:

=COUNTIF($A$2:$A$11,"="&A2)-COUNTIF($A$2:A2,A2)+1