Unique Rankif

[stroffso]

Hi, I have had a search through previous posts and none come out with what i need for this one.

I need to rank some items based off what Area it is in (Column A) and its relevant score (Column H), I need to rank the top 5 items by each area. I can get the base ranking fine but the problem is there are hundreds of rows for each area so lots of Items have the same score. I need to have the ranking unique, this is the formula I have as it stands, what do i need to add to this to make them unique? Thanks in advance

=COUNTIFS($A$2:$A$11261,A2,$H$2:$H$11261,">"&H2)+1

 

[stroffso]

Apologies I have worked out a workaround and didnt know how to delete my initial question. I added a helper column =H2+(COUNTIF($H$2:H2,H2)-1)*0.01 and then moved the initial references to H above to this column and it all worked

=IF(OR(J2=0,J2=""),"",COUNTIFS($A$2:$A$11261,A2,$J$2:$J$11261,">"&J2)+1)